On 1 February 2011 00:36, Tom Lane <[email protected]> wrote: > Thom Brown <[email protected]> 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 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
