count function alternative in postgres

From: junaid malik <junaidmalik14(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: count function alternative in postgres
Date: 2010-04-03 13:34:19
Message-ID: d18b8f53-c172-4eb1-bcc1-a86cf5fead79@u31g2000yqb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-04-03 16:17:26 Re: count function alternative in postgres
Previous Message junaidmalik14 2010-04-03 12:59:15 count function alternative in postgres