Re: overlaps() does not work as expected?

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Mario Weilguni <mweilguni(at)sime(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: overlaps() does not work as expected?
Date: 2005-05-28 03:39:14
Message-ID: 877jhk589p.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2005-05-28 03:42:28 Re: Can we simplify win32 threading code
Previous Message Michael Fuhr 2005-05-28 02:54:12 INOUT/OUT problems with IMMUTABLE