DISTINCT count(*), possible? - Mailing list pgsql-sql

From Matthew Hagerty
Subject DISTINCT count(*), possible?
Date
Msg-id 4.1.19990615225634.009e7b60@mail.venux.net
Whole thread Raw
List pgsql-sql
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


pgsql-sql by date:

Previous
From: news.postgres.sql@charmed.demon.co.uk
Date:
Subject: subscribe pgsql-sql
Next
From: Chris Bitmead
Date:
Subject: Re: [SQL] DISTINCT count(*), possible?