hi,there,
I don't see the problem except extra space, try:
SELECT COUNT(DISTINCT data) FROM media;
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.ipinc.com
On 17 Jan 2001, Mikael Hedin wrote:
> Hi,
>
> I have a table with a column (int4), and I want to know how many
> different numbers there are. In an example book I saw the query
>
> SELECT COUNT (DISTINCT data ) FROM media;
>
> by then I get
>
> ERROR: parser: parse error at or near "distinct"
>
> Is the query in error or does PostgreSQL not support this? How do I
> then get the number of distinct data from my table?
>
> TIA,
>
> Micce
>
>
> --
> Mikael Hedin, MSc +46 (0)980 79176
> Swedish Institute of Space Physics +46 (0)8 344979 (home)
> S-Box 812, 981 28 KIRUNA, Sweden +46 (0)70 5891533 (mobile)
>