Re: Range Types and extensions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Range Types and extensions
Date
Msg-id 15340.1307402635@sss.pgh.pa.us
Whole thread Raw
In response to Re: Range Types and extensions  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: Range Types and extensions
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.com> writes:
> I vote for at minimum the type itself and ANYRANGE to be in core.
> From there you could make it like arrays where the range type is
> automatically generated for each POD type.  I would consider that for
> sure on basis of simplicity in user-land unless all the extra types
> and operators are a performance hit.

Auto-generation of range types isn't going to happen, simply because the
range type needs more information than is provided by the base type
declaration.  (First, you need a btree opclass, and second, you need a
"next" function if it's a discrete type.)

By my count there are only about 20 datatypes in core for which it looks
sensible to provide a range type (ie, it's a non-deprecated,
non-composite type with a standard default btree opclass).  For that
many, we might as well just build 'em in.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Visual Studio 2010/Windows SDK 7.1 support
Next
From: Tom Lane
Date:
Subject: Re: reducing the overhead of frequent table locks - now, with WIP patch