When does count(*) returns "o rows" ?
and when does it return 1 row value being 0.
tradein_clients=# SELECT count(*) from public.eyp_listing where sno> 0 and
amount> 0 group by sno,branch,edition having count(distinct userid) > 1 ;count
-------
(0 rows)
tradein_clients=#
tradein_clients=#
tradein_clients=# SELECT count(*) from public.users where userid=-1;count
------- 0
(1 row)
tradein_clients=#
--
Regds
Mallah
----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.