RE: [QUESTIONS] COUNT (DISTINCT xxx) ? - Mailing list pgsql-hackers

From Jackson, DeJuan
Subject RE: [QUESTIONS] COUNT (DISTINCT xxx) ?
Date
Msg-id F10BB1FAF801D111829B0060971D839F267145@dal_cps.cpsgroup.com
Whole thread Raw
List 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

pgsql-hackers by date:

Previous
From: dg@illustra.com (David Gould)
Date:
Subject: Re: [HACKERS] Re: SIGPIPE gripe
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [QUESTIONS] Best way to halt an unending query.