Re: Range Types - typo + NULL string constructor - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: Range Types - typo + NULL string constructor
Date
Msg-id 1DD0DC02-6FAA-444A-B2A8-1CE04A677059@phlo.org
Whole thread Raw
In response to Re: Range Types - typo + NULL string constructor  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-hackers
On Sep21, 2011, at 19:02 , Jeff Davis wrote:
> On Wed, 2011-09-21 at 13:24 +0200, Florian Pflug wrote:
>> I've thought about this some more, and came to realize that the question
>> here really is whether
>> 
>>  floatrange(0, 'Infinity'::float, '[)')
>> 
>> and
>> 
>>  floatrange(0, NULL, '[)')
>> 
>> are the same thing or not.
> 
> The unbounded side of a range is never equal to a value in the data
> type's domain, so no, it's not the same.
> 
> I think that we pretty much settled on just using an empty string for
> infinity in the other thread, right? So that makes this a non-issue.

Agreed.

best regards,
Florian Pflug



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [v9.2] make_greater_string() does not return a string in some cases
Next
From: Tom Lane
Date:
Subject: Re: citext operator precedence fix