Request a Demo
Home   >   mailing lists

Why is NULL = unbounded for rangetypes? - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Why is NULL = unbounded for rangetypes?
Date
Msg-id OrigoEmail.b39.9039764ca71b5d10.13fbd566210@prod2
Whole thread Raw
Responses Re: Why is NULL = unbounded for rangetypes?
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Efficiency of materialized views refresh in 9.3
Next
From: Jov
Date:
Subject: backend hangs at sendto() and can't be terminated