RE: FW: Count & Distinct - Mailing list pgsql-general

From anuj
Subject RE: FW: Count & Distinct
Date
Msg-id NEBBICAAMKOEBEPFMFPBOEGGCDAA.Anuj@in-control.de
Whole thread Raw
In response to Re: FW: Count & Distinct  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List 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"'...

> >> > >select count(distinct(row)) from table;

>Right, that's the error you get from doing this in 6.5.x. The original
>poster has already been advised to upgrade to 7.0.2.

YES, previously I was using the 6.5.3-6; now I am using 7.0.2.
Now problem have sort-out thanks all of list member.
Regards,
Anuj


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Getting the result of a query using COUNT(*)
Next
From: Michael Meskes
Date:
Subject: Re: ECPG and SQL function