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

From Jeff Davis
Subject Re: Why is NULL = unbounded for rangetypes?
Date
Msg-id 1378057893.21540.18.camel@jdavis
Whole thread Raw
In response to Re: Why is NULL = unbounded for rangetypes?  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-general
On Fri, 2013-08-30 at 11:22 +0200, Andreas Joseph Krogh wrote:
> But I agree that returning NULL would be OK, then it would be easy to
> catch in queries when starting playing with range-types in queries.
> Having it implicitly mean infinity comes as a surprise, to me at
> least.

Agreed. This was discussed at the time, and the original version of
Range Types experimented with other means of specifying unbounded ranges
in order to avoid this possible confusion.

Unfortunately, everything we tried was awkward one way or another; and
we eventually made the decision to go with greater convenience, even if
it could cause some confusion.

Regards,
    Jeff Davis




pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Dump/Reload pg_statistic to cut time from pg_upgrade?
Next
From: Jeff Davis
Date:
Subject: Re: Adding ip4r to Postgresql core?