count function alternative in postgres - Mailing list pgsql-hackers

From junaidmalik14
Subject count function alternative in postgres
Date
Msg-id 28126794.post@talk.nabble.com
Whole thread Raw
Responses Re: count function alternative in postgres  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: count function alternative in postgres  (Robert Haas <robertmhaas@gmail.com>)
List 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.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Compile fail, alpha5 & gcc 4.3.3 in elog.c
Next
From: Loïc Vaumerel
Date:
Subject: Autonomous transaction