On Fri, Nov 20, 2009 at 16:11, Thom Brown <thombrown(at)gmail(dot)com> wrote:
[...]
> SELECT sum(played::integer), sum(stats_exists::integer)
> FROM matches
> WHERE origin=1 AND NOT training AND match_date > '2009-08-01';
Thank you Thom and Oliveiros, this works perfect.
(I had to use Thom's case-code since the web hotel is still using
Postgres 7.4.6, so the boolean->integer cast did not work)
--
- Rikard