count function alternative in postgres

From: junaidmalik14 <junaidmalik14(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: count function alternative in postgres
Date: 2010-04-03 12:59:43
Message-ID: 28126794.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Is there any alternative of mysql function COUNT(DISTINCT expr,[expr...]) in
postgres. We get error if we

write count like this count(distinct profile.id, profile.name, profile.age)
but it works well in mysql.

Reference url is given below

http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html#function_count-distinct

Thanks
--
View this message in context: http://old.nabble.com/count-function-alternative-in-postgres-tp28126794p28126794.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Markus Wanner 2010-04-03 13:17:30 Re: [RFC] nodeToString format and exporting the SQL parser
Previous Message Joseph Adams 2010-04-03 12:59:10 Re: Proposal: Add JSON support