Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: Issues with generate_series using integer boundaries
On 1 February 2011 00:36, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: > Thom Brown <thom(at)linux(dot)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
In response to
- Re: Issues with generate_series using integer boundaries at 2011-02-01 00:36:42 from Tom Lane
Responses
- Re: Issues with generate_series using integer boundaries at 2011-02-01 00:48:13 from Thom Brown
pgsql-hackers by date
Next: From: Thom Brown Date: 2011-02-01 00:48:13 Subject: Re: Issues with generate_series using integer boundaries Previous: From: Tom Lane Date: 2011-02-01 00:36:42 Subject: Re: Issues with generate_series using integer boundaries
pgsql-general by date
Next: From: Thom Brown Date: 2011-02-01 00:48:13 Subject: Re: Issues with generate_series using integer boundaries Previous: From: Tom Lane Date: 2011-02-01 00:36:42 Subject: Re: Issues with generate_series using integer boundaries