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
Ответ на
Список
Дерево обсуждения
more support for various frame types of window functions Hitoshi Harada <umi.tanuki@gmail.com>
Re: more support for various frame types of window functions David Fetter <david@fetter.org>
Re: more support for various frame types of window functions Hitoshi Harada <umi.tanuki@gmail.com>
Re: more support for various frame types of window functions David Fetter <david@fetter.org>
Re: more support for various frame types of window functions Hitoshi Harada <umi.tanuki@gmail.com>
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 Tom Lane <tgl@sss.pgh.pa.us>
Re: more support for various frame types of window functions Sam Mason <sam@samason.me.uk>
Re: more support for various frame types of window functions Greg Stark <gsstark@mit.edu>
Re: more support for various frame types of window functions Tom Lane <tgl@sss.pgh.pa.us>
Re: more support for various frame types of window functions Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: more support for various frame types of window functions Hitoshi Harada <umi.tanuki@gmail.com>
Heikki Linnakangas  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
Дата:
От: David Fetter
Дата:
FAQ