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

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: count (DISTINCT expression [ , ... ] ) and documentation
Date: 2008-12-26 14:34:33
Message-ID: 20081226153433.0814cb16@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-12-26 14:46:48 Re: count (DISTINCT expression [ , ... ] ) and documentation
Previous Message Emanuel Calvo Franco 2008-12-26 13:45:39 Re: Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress