Re: count function alternative in postgres

junaidmalik14 <junaidmalik14(at)gmail(dot)com> wrote:

> 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)

Is that semantically different from this SQL standard syntax?:

SELECT profile.id, profile.name, profile.age, COUNT(*)
FROM profile
GROUP BY profile.id, profile.name, profile.age;

-Kevin