Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 9774F632F70 for ; Fri, 23 Apr 2010 07:44:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46880-07 for ; Fri, 23 Apr 2010 10:44:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by mail.postgresql.org (Postfix) with ESMTP id C4FA96328E0 for ; Fri, 23 Apr 2010 07:44:12 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1O5GMk-0000UC-Q0 for pgsql-sql@postgresql.org; Fri, 23 Apr 2010 03:44:10 -0700 Message-ID: <28339789.post@talk.nabble.com> Date: Fri, 23 Apr 2010 03:44:10 -0700 (PDT) From: junaidmalik14 To: pgsql-sql@postgresql.org Subject: Re: count function alternative in postgres In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: junaidmalik14@gmail.com References: <28126792.post@talk.nabble.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201004/94 X-Sequence-Number: 34021 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(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-functions.html#function_count-distinct >> >> Thanks > > Your question has been answered several times already (including this > list) > > http://archives.postgresql.org/pgsql-hackers/2010-04/msg00182.php > http://archives.postgresql.org/pgsql-hackers/2010-04/msg00179.php > http://forums.devshed.com/postgresql-help-21/count-function-alternative-in-postgres-691450.html > http://www.dbforums.com/postgresql/1655165-count-function-alternative-postgres.html > > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > > -- View this message in context: http://old.nabble.com/count-function-alternative-in-postgres-tp28126792p28339789.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.