Hi, On 02/22/2016 08:04 PM, Corey Huinker wrote:
> > Given that counterexample, I think we not only shouldn't back-patch such a > change but should reject it altogether.Ouch, good point. The overflows are a different problem that we had better address though (still on my own TODO list)... So I should remove the bounds checking from generate_series(date,date,[int]) altogether?
I feel rather uneasy about simply removing the 'infinity' checks. Is there a way to differentiate those two cases, i.e. when the generate_series is called in target list and in the FROM part? If yes, we could do the check only in the FROM part, which is the case that does not work (and consumes arbitrary amounts of memory).
regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
