Anthony <lists(at)a1(dot)org(dot)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