we support CASE via case() which will get you there just as well.
On Nov 28, 2009, at 1:54 PM, Diego Woitasen wrote: > Does sqlalchemy support SQL IF? For example: > > select date, if(proxy_user_id <> 1, count(distinct address_id), 0) > from table group by date; > > I've solved this using literal SQL in Query() parameters but may be I > can do it using ORM. > > > -- > Diego Woitasen > XTECH > > -- > > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
