From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Range Types |
Date: | 2011-02-06 06:41:25 |
Message-ID: | 1296974485.27157.136.camel@jdavis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
New patch. All known TODO items are closed, although I should do a
cleanup pass over the code and docs.
Fixed in this patch:
* Many documentation improvements
* Added INT8RANGE
* Renamed PERIOD[TZ] -> TS[TZ]RANGE
* Renamed INTRANGE -> INT4RANGE
* Improved parser's handling of whitespace and quotes
* Support for PL/pgSQL functions with ANYRANGE arguments/returns
* Make "subtype_float" function no longer a requirement for GiST,
but it should still be supplied for the penalty function to be
useful.
There are some open issues remaining, however:
* Is typmod worth doing? I could complete it pretty quickly, but it
involves introducing a new Node type, which seems a little messy for the
benefit.
* Should pg_range reference the btree opclass or the compare function
directly?
* Should subtype_cmp default to the default btree opclass's compare
function?
* Right now only superusers can define a range type. Should we open it
up to normal users?
* Should the SQL (inlinable) function "length", which relies on
polymorphic "-", be immutable, strict, or volatile?
* Later we might consider whether we should include btree_gist in
core, to make range types more useful with exclusion constraints
out-of-the-box. This should be left for later, I'm just including this
for the archives so it doesn't get lost.
Regards,
Jeff Davis
Attachment | Content-Type | Size |
---|---|---|
rangetypes-20110205.patch.gz | application/x-gzip | 37.6 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2011-02-06 06:47:19 | Re: [COMMITTERS] pgsql: Include more status information in walsender results |
Previous Message | Kevin Grittner | 2011-02-06 05:40:23 | Re: SSI patch version 14 |