On Jun 28, 5:18 pm, Javier Guerra Giraldez <[email protected]> wrote: > On Tue, Jun 28, 2011 at 8:41 AM, akaariai <[email protected]> wrote: > > This should translate to the following SQL: > > SELECT sum(case when house.price > 41000 and house.price < 43000 then > > 1 else 0 end) as expensive_house, > > sum(case when house.price > 43000 then 1 else 0 end) as > > really_expensive_house, ... > > FROM house > > JOIN something on something.id = house.something_id > > this looks quite non-portable
How? The CASE statement is specified in SQL standard, and it is implemented in all database I have used. - Anssi -- You received this message because you are subscribed to the Google Groups "Django developers" 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/django-developers?hl=en.
