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 Tom Lane
Subject Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates
Date
Msg-id 8330.1261768106@sss.pgh.pa.us
Whole thread Raw
In response to Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates
List pgsql-hackers
Tree view 
Pavel Stehule <pavel.stehule@gmail.com> writes:
> 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.

No, because you could have more than one ORDER BY item.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: info about patch: using parametrised query in psql
Next
From: Pavel Stehule
Date:
Subject: Re: info about patch: using parametrised query in psql