Re: overlaps() does not work as expected? - Mailing list pgsql-hackers

From Greg Stark
Subject Re: overlaps() does not work as expected?
Date
Msg-id 877jhk589p.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: overlaps() does not work as expected?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> I think they may have intended to treat each time interval
> as the half-open interval [S,T), that is S <= time < T.  However
> that would leave a zero-length interval as completely empty and
> thereby arguably not overlapping anything ... which they didn't
> make it do.

Well an empty interval would be just as inconsistent. I guess they wanted
half-open intervals and they had a problem with zero-length intervals one way
or the other and just chose the one that seemed most useful.

-- 
greg



pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: INOUT/OUT problems with IMMUTABLE
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Can we simplify win32 threading code