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 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.postgresq
On Fri, 26 Dec 2008 10:43:25 -0800
David Fetter 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 distinct expres
2008/12/26 Ivan Sergio Borgonovo :
> On Fri, 26 Dec 2008 16:23:52 +0100
> "Pavel Stehule" wrote:
>
>> 2008/12/26 Ivan Sergio Borgonovo :
>> > On Fri, 26 Dec 2008 15:46:48 +0100
>> > "Pavel Stehule" wrote:
>> >
>> >> count has only one argument,
>> >
>> > then what was changed between 8.1 and 8.2
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 [, exp
On Fri, 26 Dec 2008 16:23:52 +0100
"Pavel Stehule" wrote:
> 2008/12/26 Ivan Sergio Borgonovo :
> > On Fri, 26 Dec 2008 15:46:48 +0100
> > "Pavel Stehule" wrote:
> >
> >> count has only one argument,
> >
> > then what was changed between 8.1 and 8.2 to change the docs?
> > None of the functions l
2008/12/26 Ivan Sergio Borgonovo :
> On Fri, 26 Dec 2008 15:46:48 +0100
> "Pavel Stehule" 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.ht
On Fri, 26 Dec 2008 15:46:48 +0100
"Pavel Stehule" 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
aggregate(distinct exp [,exp
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 ma
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 expres
