Re: count function alternative in postgres

junaidmalik14 <junaidmalik14@gmail.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