Hi,
I got some unexpected results from a sum().. just wondering
if it's a bug of any sort, or if i just should have been expecting it..
SELECT sum(foo) FROM mytable WHERE active = 1;
Now lets say that no rows are active = 1, then this query returns
1 blank row..
I would have expected either
1: a result of zero
or
2: zero rows returned..
oh, btw this is pgsql 7.0.2 on fbsd.
anyone ?
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose
PGP Public Key : http://bignose.hub.org/public.txt