Re: multiple count functions in a select statement

-----Original Message-----
From: Jeannie Stevenson [mailto:webteam@wes-state.com]
Sent: Thursday, May 27, 2004 9:39 AM
To: postgresql
Subject: [GENERAL] multiple count functions in a select statement

Hello list

 

I'm a MSSQL convert and I'm running postgresql 7.2

 

I'm trying to create a statement in which display multiple counts on a table

 

In MSSQL I would use

 

select

count_1=(select count(ad_code) AS "CP" from leads where ad_code = '555'),

count_2=(select count(ad_code) AS HED" from leads where ad_code = '222'),

etc

 

 

I've searched the docs but to avail.

 

Any help, suggestions, pointers, would be appreciated

 

Thanks

 

Jeannie