Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA60029 for ; Tue, 15 Jun 1999 22:59:43 -0400 (EDT) (envelope-from matthew@venux.net) Received: from thunder (net177138.hcv.com [209.153.177.138]) by redbox.venux.net (Postfix) with SMTP for id 17A462E20B; Tue, 15 Jun 1999 22:56:54 -0400 (EDT) Message-Id: <4.1.19990615225634.009e7b60@mail.venux.net> X-Sender: mhagerty@mail.venux.net X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Tue, 15 Jun 1999 22:59:54 -0400 To: pgsql-sql@postgreSQL.org From: Matthew Hagerty Subject: DISTINCT count(*), possible? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings, Can someone tell me how I can get this to work? select DISTINCT count(address1) from aro; returns 240, which is wrong. But this: select DISTINCT address1 from aro; returns 219, which is exactally what I am looking for, minus the query output. I don't need the tuples, just a count of distinct addresses. Thanks, Matthew