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;
any ideas please?
http://www.carfolio.com/ Searchable database of 10 000+ car specs
pgsql-general by date
|Next:||From: Bill Moran||Date: 2004-03-01 00:55:15|
|Subject: Re: count(1) return 0?|
|Previous:||From: Zak McGregor||Date: 2004-02-29 23:17:06|
|Subject: Re: dumping fields from Perl|