Re: FW: Count & Distinct

I find that if I create the table described in the email, in psql I recieve
'ERROR:  Attribute 'row' not found'...

But this isn't exactly 'ERROR:  parser: parse error at or near
"distinct"'...


----- Original Message -----
From: "John McKown" <jmckown@prodigy.net>
To: "anuj" <Anuj@in-control.de>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, August 24, 2000 4:55 AM
Subject: Re: FW: [GENERAL] Count & Distinct


> 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
> > >
> > >
> >
> >
>