RE: [QUESTIONS] COUNT (DISTINCT xxx) ?

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: Marin D <marin(at)iclub(dot)techno-link(dot)com>, pgsql-questions(at)postgreSQL(dot)org
Cc: PostgreSQL Hackers Mailing List <pgsql-hackers(at)hub(dot)org>
Subject: RE: [QUESTIONS] COUNT (DISTINCT xxx) ?
Date: 1998-05-04 19:32:39
Message-ID: F10BB1FAF801D111829B0060971D839F267145@dal_cps.cpsgroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Hi!
>
> Is there a way excluding temp tables to make a COUNT (DISTINCT xxx)
> query?
>
> Thanx for the attention!
>
> Marin
>
I'd like to know as well. I think that someone was trying to implement
sub-selects in aggregate functions, did that get done?
select distinct count(col_name) from table_name;
doesn't work BTW, it gives that number of rows in the table even if
col_name has duplicates.

-DEJ

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter T Mount 1998-05-04 19:51:06 Re: [HACKERS] Re: SIGPIPE gripe
Previous Message David Gould 1998-05-04 19:31:42 Re: [HACKERS] Re: SIGPIPE gripe