Re: count function alternative in postgres - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: count function alternative in postgres
Date
Msg-id 4BB9B1A80200002500030457@gw.wicourts.gov
Whole thread Raw
In response to count function alternative in postgres  (junaidmalik14 <junaidmalik14@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SPAM]Re: Questions about 9.0 release note
Next
From: Robert Haas
Date:
Subject: Re: Autonomous transaction