Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates
Дата
Msg-id 7949.1261766632@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ORDER BY clause in aggregate doesn't work well with multi argument aggregates  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: ORDER BY clause in aggregate doesn't work well with multi argument aggregates  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
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.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: info about patch: using parametrised query in psql
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: info about patch: using parametrised query in psql