Why is NULL = unbounded for rangetypes?
От
Andreas Joseph Krogh
Тема
Why is NULL = unbounded for rangetypes?
Дата
Msg-id
OrigoEmail.b39.9039764ca71b5d10.13fbd566210@prod2
Список
Дерево обсуждения
Why is NULL = unbounded for rangetypes? Andreas Joseph Krogh <andreak@officenet.no>
Re: Why is NULL = unbounded for rangetypes? Jeff Davis <pgsql@j-davis.com>
Re: Why is NULL = unbounded for rangetypes? Andreas Joseph Krogh <andreak@officenet.no>
Re: Why is NULL = unbounded for rangetypes? Jeff Davis <pgsql@j-davis.com>
Re: Why is NULL = unbounded for rangetypes? Andreas Joseph Krogh <andreak@officenet.no>
Re: Why is NULL = unbounded for rangetypes? Jeff Davis <pgsql@j-davis.com>
Hi.
Both of these queries return TRUE because NULL means "unmounded":
select daterange('2013-07-01' :: DATE, null, '[]') && daterange('2013-07-04' :: DATE, '2013-07-30' :: DATE, '[]');
select daterange(null, '2013-08-11' :: DATE, '[]') && daterange('2013-07-04' :: DATE, '2013-07-30' :: DATE, '[]');What is the rational behind this behavior of NULL?
--
Andreas Joseph Krogh <andreak@officenet.no> mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc
Andreas Joseph Krogh <andreak@officenet.no> mob: +47 909 56 963
Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no
Public key: http://home.officenet.no/~andreak/public_key.asc
В списке pgsql-general по дате отправления
