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

From Andrew Dunstan
Subject Re: Range Types: << >> -|- ops vs empty range
Date
Msg-id 4D55778B.70801@dunslane.net
Whole thread Raw
In response to Re: Range Types: << >> -|- ops vs empty range  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

On 02/11/2011 12:36 PM, Robert Haas wrote:
> 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?

I have no particular opinion on that, but if we do then ISTM all the 
above (and particularly the last) should return false if either operand 
is an empty range.

cheers

andrew


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Change pg_last_xlog_receive_location not to move backwards
Next
From: Alex Hunsaker
Date:
Subject: Re: Careful PL/Perl Release Not Required