Re: FW: Count & Distinct
От | Ryan Williams |
---|---|
Тема | Re: FW: Count & Distinct |
Дата | |
Msg-id | 005501c00df1$c1df2500$c330cc40@crusher обсуждение исходный текст |
Ответ на | Re: FW: Count & Distinct (John McKown <jmckown@prodigy.net>) |
Ответы |
Re: FW: Count & Distinct
|
Список | pgsql-general |
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 > > > > > > > > > > >
В списке pgsql-general по дате отправления: