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