junaidmalik14 <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
