Re: add more frame types in window functions (ROWS)

Поиск
Список
Период
Сортировка
Искать
От
Hitoshi Harada
Тема
Re: add more frame types in window functions (ROWS)
Дата
Msg-id
e08cc0400911142311o1b106606g590495aabaf7ff74@mail.gmail.com
Ответ на
Список
Дерево обсуждения
add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Tom Lane <tgl@sss.pgh.pa.us>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Tom Lane <tgl@sss.pgh.pa.us>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: add more frame types in window functions (ROWS) Greg Smith <greg@2ndquadrant.com>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Re: add more frame types in window functions (ROWS) Hitoshi Harada <umi.tanuki@gmail.com>
Thanks for your review.

2009/11/15 Andrew Gierth :
> Hi, I've started reviewing your patch.
>
> I've already found some things that need work:
>
>  - missing _readWindowFrameDef function (all nodes that are output
>   from parse analysis must have both _read and _out functions,
>   otherwise views can't work)

I added _outWindowFramedef() but seem to forget _read one. Will add it.

>
>  - the A_Const nodes should probably be transformed to Const nodes in
>   parse analysis, since A_Const has no _read/_out functions, which
>   means changing the corresponding code in the executor.

Thanks for this comment. I hadn't determined which node should be used
as a value node passed to executor. Including Tom's comment, I must
consider which should be again.

Regards,


-- 
Hitoshi Harada

В списке pgsql-hackers по дате отправления
От: Hitoshi Harada
Дата:
От: Hitoshi Harada
Дата:
Сообщение: NULL input for array_agg()?
FAQ