Postgres Pro
Downloads
Home   >   mailing lists

Re: count( distinct x ) - Mailing list pgsql-sql

From Tom Lane
Subject Re: count( distinct x )
Date
Msg-id 11661.975352224@sss.pgh.pa.us
Whole thread Raw
In response to count( distinct x )  (Anthony <lists@a1.org.uk>)
List pgsql-sql
Tree view 
Anthony <lists@a1.org.uk> writes:
>     select count( distinct area ) from areapostcode where postcode like
> 'BS1%'
> the above statement fails with
>     ERROR:  parser: parse error at or near "distinct"

What Postgres version are you running?  Support for count(distinct foo)
was added in 7.0, IIRC.
        regards, tom lane

pgsql-sql by date:

Previous
From: Anthony
Date:
Subject: Re: count( distinct x )
Next
From: Anthony
Date:
Subject: Re: count( distinct x )