Request a Demo
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 [email protected]
Whole thread Raw
In response to Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates  (Tom Lane <[email protected]>)
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 <[email protected]>:
> Pavel Stehule <[email protected]> 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