Re: [SQL] count function alternative in postgres

Thanks Ben. It works fine. Junaid. Ben Morrow-2 wrote: > > Quoth junaidmali...@gmail.com (junaidmalik14): >> >> Is there any alternative of mysql function COUNT(DISTINCT expr,[expr...]) >> in >> postgres. We get error if we >> >> write

Re: [SQL] count function alternative in postgres

Thanks tkellerer. Junaid tkellerer wrote: > > junaidmalik14 wrote on 03.04.2010 14:58: >> >> Is there any alternative of mysql function COUNT(DISTINCT expr,[expr...]) >> in >> postgres. We get error if we >> >> write count like this count(distinc

[SQL] count function alternative in postgres

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) but it works well in mysql. Reference url is given below http://dev.mysql.com/doc/refman/5.1/en/group-by-functi