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
Hello
count has only one argument,
try:
postgres=# select * from fooa;
a | b
+
10 | 20
(1 row)
postgres=# select count(distinct a,b) from fooa;
ERROR: function count(integer, integer) does not exist
LINE 1: select count(distinct a,b) from fooa;
^
HINT: No function
On Fri, 26 Dec 2008 15:46:48 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
count has only one argument,
then what was changed between 8.1 and 8.2 to change the docs?
None of the functions listed in:
http://www.postgresql.org/docs/8.2/static/functions-aggregate.html
seems to support
2008/12/26 Ivan Sergio Borgonovo m...@webthatworks.it:
On Fri, 26 Dec 2008 15:46:48 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
count has only one argument,
then what was changed between 8.1 and 8.2 to change the docs?
None of the functions listed in:
On Fri, 26 Dec 2008 16:23:52 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
2008/12/26 Ivan Sergio Borgonovo m...@webthatworks.it:
On Fri, 26 Dec 2008 15:46:48 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
count has only one argument,
then what was changed between 8.1 and
On Fri, Dec 26, 2008 at 03:34:33PM +0100, Ivan Sergio Borgonovo wrote:
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 [,
2008/12/26 Ivan Sergio Borgonovo m...@webthatworks.it:
On Fri, 26 Dec 2008 16:23:52 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
2008/12/26 Ivan Sergio Borgonovo m...@webthatworks.it:
On Fri, 26 Dec 2008 15:46:48 +0100
Pavel Stehule pavel.steh...@gmail.com wrote:
count has only
On Fri, 26 Dec 2008 10:43:25 -0800
David Fetter da...@fetter.org wrote:
On Fri, Dec 26, 2008 at 03:34:33PM +0100, Ivan Sergio Borgonovo
wrote:
I noticed that starting from 8.2 the documentation at
http://www.postgresql.org/docs/8.2/interactive/sql-expressions.html
say that multiple
On Fri, Dec 26, 2008 at 08:03:30PM +0100, Ivan Sergio Borgonovo wrote:
On Fri, 26 Dec 2008 10:43:25 -0800
David Fetter da...@fetter.org wrote:
On Fri, Dec 26, 2008 at 03:34:33PM +0100, Ivan Sergio Borgonovo
wrote:
I noticed that starting from 8.2 the documentation at