From: | Anthony <lists(at)a1(dot)org(dot)uk> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: count( distinct x ) |
Date: | 2000-11-27 19:20:01 |
Message-ID: | 3A22B3E1.68A66ABD@a1.org.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Tom Lane wrote:
> 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
select version();
version
-------------------------------------------------------------------
PostgreSQL 6.5.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)
bugger!
any ideas how to get same result at relative speed with different query?
Thanks Tom.
From | Date | Subject | |
---|---|---|---|
Next Message | Bernie Huang | 2000-11-27 19:22:45 | a script that queries database periodically |
Previous Message | Tom Lane | 2000-11-27 19:10:24 | Re: count( distinct x ) |