Re: [SQL] count( distinct x )

[Tom Lane]

Anthony <[EMAIL PROTECTED]> 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