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