On Tue, Jun 28, 2011 at 8:41 AM, akaariai <akaar...@cc.hut.fi> 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 -- Javier -- You received this message because you are subscribed to the Google Groups "Django developers" group. To post to this group, send email to django-developers@googlegroups.com. To unsubscribe from this group, send email to django-developers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-developers?hl=en.