On Mon, Feb 22, 2016 at 6:52 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Oooh ... actually, that works today if you consider the SRF-in-targetlist
> case:
>
> regression=# select generate_series(now(), 'infinity', '1 day') limit 10;
> generate_series
> -------------------------------
> 2016-02-21 16:51:03.303064-05
> 2016-02-22 16:51:03.303064-05
> 2016-02-23 16:51:03.303064-05
> 2016-02-24 16:51:03.303064-05
> 2016-02-25 16:51:03.303064-05
> 2016-02-26 16:51:03.303064-05
> 2016-02-27 16:51:03.303064-05
> 2016-02-28 16:51:03.303064-05
> 2016-02-29 16:51:03.303064-05
> 2016-03-01 16:51:03.303064-05
> (10 rows)
>
> Time: 8.457 ms
>
> 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)...
--
Michael