try with func.if_(....) On Sunday 05 April 2009 21:19:29 Wouter van Vliet wrote: > Hi Folks, > > After an hour or so of browsing the net and documentations, getting > increasingly frustrated and being about to just - nah, I didn't > really consider throwing sqlalchemy out of my project. But still. > Anyway, I'm trying to make a select-query which would send > something like this to postgres: > > SELECT sum(if(type = "purchase", value, 0)), user_id > FROM transactions > GROUP BY user_id > > But no matter how hard I try, I can't find something that works > like just being able to do > > sql.func.if( ... ) > > when I do that, I get the obvious syntax error. > > Any help is much appreciated. > Wouter
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
