Re: Add generate_series(date,date) and generate_series(date,date,integer)

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