RE: FW: Count & Distinct

Поиск
Список
Период
Сортировка
От anuj
Тема RE: FW: Count & Distinct
Дата
Msg-id NEBBICAAMKOEBEPFMFPBOEGGCDAA.Anuj@in-control.de
обсуждение исходный текст
Ответ на Re: FW: Count & Distinct  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Getting the result of a query using COUNT(*)
Следующее
От: Michael Meskes
Дата:
Сообщение: Re: ECPG and SQL function