Re: Range Types: << >> -|- ops vs empty range - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Range Types: << >> -|- ops vs empty range
Date
Msg-id AANLkTim+4LwmGLRxncSxXZ0hSihY4BQLO24kOhpMnM1H@mail.gmail.com
Whole thread Raw
In response to Re: Range Types: << >> -|- ops vs empty range  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Range Types: << >> -|- ops vs empty range  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
On Fri, Feb 11, 2011 at 12:26 PM, Jeff Davis <pgsql@j-davis.com> wrote:
> On Fri, 2011-02-11 at 12:03 -0500, Robert Haas wrote:
>> For what it's worth, my completely uninformed opinion is that
>> comparison operators shouldn't error out.  I haven't read the patch so
>> I'm not sure what those operators are defined to do, though.
>
> ">>" means "strictly right of"
> "<<" means "strictly left of"
> "-|-" means "adjacent" (touching but not overlapping)
>
> I'm open to suggestion about how those behave with empty ranges.

Hmm, so an empty range is a range that includes nothing at all, right?Not "everything in the world"?

Are we sure we even want to have that concept?

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER EXTENSION UPGRADE, v3
Next
From: Alex Hunsaker
Date:
Subject: Re: Careful PL/Perl Release Not Required