Re: more support for various frame types of window functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: more support for various frame types of window functions
Дата
Msg-id 27170.1257778913@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: more support for various frame types of window functions  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: more support for various frame types of window functions
Re: more support for various frame types of window functions
Список pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> One idea is to take a copy of the state datum after each row. Then,
> instead of initializing the aggregate from scratch, you can "roll back"
> to an earlier copied state. It doesn't always help, but might be a part
> of the solution.

That requires that you know how to copy the aggregate's state.  You do
not.  (In some cases the aggregate function has extra state besides the
nominal transition datum...)
        regards, tom lane


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

Предыдущее
От: Hitoshi Harada
Дата:
Сообщение: Re: more support for various frame types of window functions
Следующее
От: David Fetter
Дата:
Сообщение: Re: more support for various frame types of window functions