Re: 9.2 Beta: intersection of daterange
От | Misa Simic |
---|---|
Тема | Re: 9.2 Beta: intersection of daterange |
Дата | |
Msg-id | 7137589199374978896@iso-8859-1msgid обсуждение исходный текст |
Ответ на | 9.2 Beta: intersection of daterange (Brar Piening <brar@gmx.de>) |
Список | pgsql-hackers |
I think result is ok... 2010-01-04 is not inside first range... Sent from my Windows Phone From: Brar Piening Sent: 16/05/2012 09:53 To: pgsql-hackers Subject: [HACKERS] 9.2 Beta: intersection of daterange I'm currently doing some tests on range types: tests=# SELECT int8range(5,15) * int8range(10,20) AS intersection; intersection -------------- [10,15) (1 Zeile) tests=# tests=# SELECT '[2010-03-15,2010-05-22)'::daterange * '[2010-01-04,)'::daterange AS intersection; intersection ------------------------- [2010-03-15,2010-05-22) (1 Zeile) Does the second query trigger a bug or am I misunderstanding something? I would expect [2010-01-04,2010-05-22) as result. Regards, Brar -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления: