Range Types

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

Responses

Browse pgsql-hackers by date

  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