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@hub.org [mailto:pgsql-general-owner@hub.org]On
Behalf Of sridhvenk@yahoo.com
Sent: Wednesday, August 23, 2000 9:12 AM
To: J. Atwood
Cc: pgsql-general@postgresql.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
>
>