count(1) return 0? - Mailing list pgsql-general

Hi all

is it possible to get a count(1) statemment, for example here:

select count(1) from results where fixture=4916 and winner=away group by winner;

to return a 0 value instead of absolutely nothing if no rows match fixture=4916
and winner=away? I get absolutely no results at all.


select count(1) from results where fixture=4916 and winner=home group by winner;
 count
-------
(0 rows)

any ideas please?

Thanks

ciao

Zak

--
========================================================================
http://www.carfolio.com/        Searchable database of 10 000+ car specs
========================================================================