From: | Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | More frame options in window functions |
Date: | 2009-12-31 09:49:26 |
Message-ID: | e08cc0400912310149me7150cek3c9aa92e4d396ac3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
Attachment | Content-Type | Size |
---|---|---|
more_frame_options.20091231.patch.gz | application/x-gzip | 22.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2009-12-31 10:30:47 | Re: [PATCH] Windows x64 [repost] |
Previous Message | Peter Eisentraut | 2009-12-31 09:16:30 | Re: Thread safety and libxml2 |