overlaps() does not work as expected?

Поиск
Список
Период
Сортировка
От Mario Weilguni
Тема overlaps() does not work as expected?
Дата
Msg-id 200505271835.32416.mweilguni@sime.com
обсуждение исходный текст
Ответы Re: overlaps() does not work as expected?  (Alvaro Herrera <alvherre@surnet.cl>)
Re: overlaps() does not work as expected?  (Jochem van Dieten <jochemd@gmail.com>)
Re: overlaps() does not work as expected?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I've quite some trouble with the overlaps function:
SELECT overlaps('9.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date, 
'9.6.2005'::date);
returns true (these are german timestamps dd.mm.yyyy)

SELECT overlaps('8.6.2005'::date, '9.6.2005'::date, '9.6.2005'::date, 
'9.6.2005'::date); 
returns false

Is this a bug or a (quite strange) feature?

Thanks!


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: Multiple-statement Rules Incompatible With Constraints
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cost of XLogInsert CRC calculations