Re: Range Type constructors

On Thu, Feb 10, 2011 at 1:41 PM, Jeff Davis <pgsql(at)j-davis(dot)com> wrote:
> This might solve the constructor problem nicely if we could do things
> like:
>  RANGE[10,20)
> But I have a feeling that will either cause a bizarre problem with the
> grammar, or someone will think it's not very SQL-like.

I think won't cause any problem at all if RANGE is fully reserved, but
like you say we probably don't want to do that unless it's absolutely
necessary, and if you don't actually need to be able to type in foo
RANGE JOIN bar then it probably isn't.

I think your proposed naming schema for constructors is pretty
reasonable, except I might use "o" for open and "c" for closed rather
than "i" and "_", i.e. range_oo(), range_oc(), range_co(), range_cc().
If that'll get us by without fully reserving RANGE then I'd certainly
be in favor of doing it that way. I was just saying - if we were
inevitably going to have to reserve RANGE, then we could try to
squeeze a little more out of it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company