Re: Issues with generate_series using integer boundaries

Thom Brown <thom@linux.com>

From: Thom Brown <thom@linux.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: PGSQL Mailing List <pgsql-general@postgresql.org>

Date: 2011-02-01T00:41:25Z

Lists: pgsql-hackers

On 1 February 2011 00:36, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Thom Brown <thom@linux.com> writes:
>> Actually, those lower bound errors aren't related to generate_series,
>> but I'd still like to know why -2147483648::int4 is out of range.
>
> :: binds tighter than - (and everything else too).  Write
> (-2147483648)::int4 instead.

D'oh.  You explained this to me before.  This time I'll endeavour to
remember it.  At least that explains the problem I created for myself
with lower boundaries.

-- 
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935