X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 09B2B9DCAE5 for ; Sat, 10 Dec 2005 21:17:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80686-06 for ; Sat, 10 Dec 2005 21:17:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from viefep17-int.chello.at (viefep17-int.chello.at [213.46.255.23]) by postgresql.org (Postfix) with ESMTP id 4AA269DCAB8 for ; Sat, 10 Dec 2005 21:17:10 -0400 (AST) Received: from OTTO ([213.222.166.137]) by viefep17-int.chello.at (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with SMTP id <20051211011713.VBSZ15321.viefep17-int.chello.at@OTTO>; Sun, 11 Dec 2005 02:17:13 +0100 Message-ID: <006601c5fdf0$9e2f5e50$0200a8c0@OTTO> From: =?iso-8859-1?Q?Havasv=F6lgyi_Ott=F3?= To: "Foster, Stephen" , "'Jaime Casanova'" Cc: References: <005c01c5fdf0$01b90c10$2101a8c0@cfgod> Subject: Re: select count of distinct rows Date: Sun, 11 Dec 2005 02:17:13 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/81 X-Sequence-Number: 23623 Hi, This works for me but the result is not that what is expected. I returns with the number of rows in the table, and the distinct has no effect because there is only one row in the result. Best Regards, Otto ----- Original Message ----- From: "Foster, Stephen" To: "'Havasvölgyi Ottó'" ; "'Jaime Casanova'" Cc: Sent: Sunday, December 11, 2005 2:12 AM Subject: Re: [SQL] select count of distinct rows Well this should work but I tried it and it didn't. SELECT DISTINCT COUNT(*) FROM mytable; -----Original Message----- From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Havasvölgyi Ottó Sent: Saturday, December 10, 2005 7:07 PM To: Jaime Casanova Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] select count of distinct rows Hi, Yes, I need to compare all fields. Well, in this case it does not. Is this impossible? Thanks, Otto ----- Original Message ----- From: "Jaime Casanova" To: "Havasvölgyi Ottó" Cc: Sent: Sunday, December 11, 2005 1:57 AM Subject: Re: [SQL] select count of distinct rows On 12/10/05, Havasvölgyi Ottó wrote: > Hi, > > I would like to select the count of distinct rows in a table. > > SELECT COUNT(DISTINCT *) FROM mytable; > are really all the fields distincts? the table doesn't have a pk? > This does not work. How can I do it with Postgres? > > Thanks, > Otto > -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.13/197 - Release Date: 12/9/2005 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.13.13/197 - Release Date: 12/9/2005 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org