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)
Список
Дерево обсуждения
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
Дата: