Horton

Re: Issues with generate_series using integer boundaries

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

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thom Brown <thom@linux.com>
Cc: PGSQL Mailing List <pgsql-general@postgresql.org>
Date: 2011-02-01T01:05:25Z
Lists: pgsql-hackers 
Thom Brown <thom@linux.com> writes:
> I've noticed that if I try to use generate_series to include the upper
> boundary of int4, it never returns:

I'll bet it's testing "currval > bound" without considering the
possibility that incrementing currval caused an overflow wraparound.
We fixed a similar problem years ago in plpgsql FOR-loops...

			regards, tom lane