On 25-06-13 13:38, Pavlo Lavrenenko wrote:
>> SELECT
>> SUM( CASE WHEN seen_flag = 0 THEN 1 ELSE 0 END) AS unseen,
>> SUM( CASE WHEN seen_flag = 1 THEN 1 ELSE 0 END) AS seen,
>> SUM( CASE WHEN recent_flag = 1 THEN 1 ELSE 0 END) AS recent
>> FROM %smessages WHERE mailbox_idnr=? AND status < %d
>
> This variant is slightly more preferable because it lacks GROUP BY
> statement which adds
> implicit ORDER BY.
It appears to be a bit faster on postgresql as well. It is also more
readable.
Thanks.
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
Dbmail-dev mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
