More frame options in window functions

Поиск
Список
Период
Сортировка
От Hitoshi Harada
Тема More frame options in window functions
Дата
Msg-id e08cc0400912310149me7150cek3c9aa92e4d396ac3@mail.gmail.com
обсуждение исходный текст
Ответы Re: More frame options in window functions  (Hitoshi Harada <umi.tanuki@gmail.com>)
Список pgsql-hackers
Attached is the fix pointed out in the previous CommitFest plus RANGE
offset support.

*fix
- move window regression test to another parallel group, but regarding
the limitation of 20 per group the union test goes to the group the
window test belonged to.
- allow NULL iswindowagg as an argument of AggGetMemoryContext
- change view name to longer one

*RANGE offset
- allow all of RANGE BETWEEN <value> PRECEDING/FOLLOWING AND <value>
PRECEDING/FOLLOWING for any data types that support ORDER BY and
additions/subtractions, which is extended design to the spec. The spec
says data types allowed in RANGE offset are only numeric and temporal
ones but we don't have such limitation.
- add "+"/"-" operator search code in parsing, which is used to
calculate frame bound, but I'm not sure if this is right approach.
- add more regression tests


Regards,


--
Hitoshi Harada

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Thread safety and libxml2
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: [PATCH] Windows x64 [repost]