Postgres Pro
Downloads
Home   >   mailing lists

Re: count(distinct col) - Mailing list pgsql-novice

From Tom Lane
Subject Re: count(distinct col)
Date
Msg-id 28401.965167180@sss.pgh.pa.us
Whole thread Raw
In response to count(distinct col)  ("Chau, Artemis" <artemis.chau@intel.com>)
List pgsql-novice
Tree view 
"Chau, Artemis" <artemis.chau@intel.com> writes:
> What is the equivalent of
> "select count(distinct col) from tbl" in PGSQL?

That's easy, "select count(distinct col) from tbl".

(If you're running 7.0 that is.  If not, why not?)

            regards, tom lane

pgsql-novice by date:

Previous
From: "Chau, Artemis"
Date:
Subject: count(distinct col)
Next
From: "Chau, Artemis"
Date:
Subject: RE: count(distinct col)