FW: Count & Distinct

> >>> select count(distinct(row)) from table;
hi,
I have also tried but I am geting an error.

***************
tempdb=> \d tbltemp
Table = tbltemp
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| id | int4 |
4 |
| name | varchar() |
40 |
+----------------------------------+----------------------------------+-----
--+
tempdb=> select count(distinct(row)) from tbltemp;
ERROR: parser: parse error at or near "distinct"
tempdb=>
***************

Thanks
Anuj

-----Original Message-----
From: pgsql-general-owner(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of sridhvenk(at)yahoo(dot)com
Sent: Wednesday, August 23, 2000 9:12 AM
To: J. Atwood
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Count & Distinct

It works fine. Please try again

On Wed, 23 Aug 2000, J. Atwood wrote:

> Search a lot of archives and have come up with very little (much old)
>
> obviously
>
> >>> select count(distinct(row)) from table;
>
> Does not work so what is the work around? I have tried a bunch of stuff.
>
> Thanks,
> J
>
>