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.

Reply via email to