Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates
Date
Msg-id 162867790912251103s1aadd500s831ac403f0970cac@mail.gmail.com
Whole thread Raw
In response to Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates
List pgsql-hackers
Tree view 
2009/12/25 Tom Lane <tgl@sss.pgh.pa.us>:
> Pavel Stehule <pavel.stehule@gmail.com> writes:
>> It is maybe a bug. I cannot use ORDER BY clause in two parameter aggregate.
>
> I think you don't understand the syntax.  Put the aggregate arguments
> first, then the ORDER BY.
>

I was wrong. But it should be syntax error no?

SELECT foo(expr ORDER BY expr, .....)

currently it quietly ignore arguments over ORDER BY clause.

Pavel


>                        regards, tom lane
>

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates
Next
From: Robert Haas
Date:
Subject: Re: info about patch: using parametrised query in psql