count (DISTINCT expression [ , ... ] ) and documentation

Поиск
Список
Период
Сортировка
От Ivan Sergio Borgonovo
Тема count (DISTINCT expression [ , ... ] ) and documentation
Дата
Msg-id 20081226153433.0814cb16@dawn.webthatworks.it
обсуждение исходный текст
Ответы Re: count (DISTINCT expression [ , ... ] ) and documentation  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: count (DISTINCT expression [ , ... ] ) and documentation  (David Fetter <david@fetter.org>)
Список pgsql-general
I noticed that starting from 8.2 the documentation at
http://www.postgresql.org/docs/8.2/interactive/sql-expressions.html
say that multiple distinct expressions are supported

aggregate_name (DISTINCT expression [, expression] )

While previous docs just listed one:

aggregate_name (DISTINCT expression)

Still I'm using 8.3 and

select count(distinct c1, c2) from table1;

report:

No function matches the given name and argument types. You might
need to add explicit type casts.

What should I write in spite of?

select count(distinct c1, c2) from table1;

--
Ivan Sergio Borgonovo
http://www.webthatworks.it


В списке pgsql-general по дате отправления:

Предыдущее
От: "Emanuel Calvo Franco"
Дата:
Сообщение: Re: Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: count (DISTINCT expression [ , ... ] ) and documentation