Skip site navigation (1) Skip section navigation (2)

More frame options in window functions

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Attached is the fix pointed out in the previous CommitFest plus RANGE
offset support.

- 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


Hitoshi Harada

Attachment: more_frame_options.20091231.patch.gz
Description: application/x-gzip (22.8 KB)


pgsql-hackers by date

Next:From: Magnus HaganderDate: 2009-12-31 10:30:47
Subject: Re: [PATCH] Windows x64 [repost]
Previous:From: Peter EisentrautDate: 2009-12-31 09:16:30
Subject: Re: Thread safety and libxml2

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group