Re: count( distinct x )

> The problem I have is with this statement:
>
>     select count( distinct area ) from areapostcode where postcode like
> 'BS1%'
>
> the above statement fails with
>     ERROR:  parser: parse error at or near "distinct"
>
> I am not the greatest when it comes to SQL, but the pgsql docs implied
> that the above would work.
>
> What I am trying to do is get a count of the no of matches from the
> statement below
>     select distinct area from areapostcode where postcode like 'BS1%'
>
> Not the count of:
>     select area from areapostcode where postcode like 'BS1%'
>

I don't have where to try it, but have you tried:

select distinct count(area) from areapostcode where postcode like 'BS1%'

Rodrigo F.