I'm confused, your SELECT uses the variable "row", but there is no such
variable in your table?
John
On Thu, 24 Aug 2000, anuj wrote:
>
>
> > >>> 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
> >
> >
>
>
