use this: http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/expressions.html#sqlalchemy.sql.expression.distinct
On Feb 2, 2009, at 7:53 PM, Stuart Axon wrote: > > I've got a fairly simple query in postgres... any idea how I do this > in sqlalchemy - I couldn't find any info about this > > select > count(distinct device_id) > from > externalbuild > join > build > on > build.id = externalbuild.build_id > where > external_id = '1' > and not > is_known > > > BTW, the recent work looks good - might even help me convert my > other queries from sql... I thought this one > was the simplest, but failed here too :-\ > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---