Re: overlaps() does not work as expected?

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: overlaps() does not work as expected?
Дата
Msg-id 877jhk589p.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: overlaps() does not work as expected?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: INOUT/OUT problems with IMMUTABLE
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: Can we simplify win32 threading code