Re: count( distinct x )

Jose Rodrigo Fernandez Menegazzo wrote:

> > 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.

yes, it responds as if distinct is not in the query string.

Thanks,
Bap.