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
