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

From Jeff Davis
Subject Re: Range Types - typo + NULL string constructor
Date
Msg-id 1318267869.1724.132.camel@jdavis
Whole thread Raw
In response to Re: Range Types - typo + NULL string constructor  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Range Types - typo + NULL string constructor
List pgsql-hackers
On Mon, 2011-10-10 at 12:53 -0400, Tom Lane wrote:
> > The "canonicalize" function (specified at type creation time) allows you
> > to specify the canonical output representation. So, I can change the
> > canonical form for discrete ranges to use '[]' notation if we think
> > that's more expected.
> 
> What if I write '[1,INT_MAX]'::int4range?  The open-parenthesis form will
> fail with an integer overflow.  I suppose you could canonicalize it to
> an unbounded range, but that seems unnecessarily surprising.

So, are you suggesting that I canonicalize to '[]' then? That seems
reasonable to me, but there's still some slight awkwardness because
int4range(1,10) would be '[1,9]'.

Regards,Jeff Davis



pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: SET variable - Permission issues
Next
From: Thom Brown
Date:
Subject: Re: COUNT(*) and index-only scans