Removing duplicates

[Eduardo]

Hi,
Is there any function in sqlalchemy that filters out duplicates?
For example the following rows satisfy a query:
1. (john, 23 ,  lpgh )
2.(steve , 35 , dbr )
3. (john ,76, qwe)
4. (mark, 35, epz)
I would like that my query results contain only one row with john (either 1 or 3 which one is not important) or with 35 (either 2 or 4).
I tried with distinct(col) but it could not do the work.
Thanks

[Ryan Kelly]

You could try DISTINCT ON in combination with a UNION... maybe. DISTINCT
ON is documented here:
http://docs.sqlalchemy.org/en/latest/orm/query.html#sqlalchemy.orm.query.Query.distinct
and I'm not sure which dialects support this, apart from PostgreSQL.

> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
> To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/xnt0Zo5tSPUJ.
> To post to this group, send email to sqlal...@googlegroups.com.
> To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
>

-Ryan