Re: Add generate_series(date,date) and generate_series(date,date,integer) - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: Add generate_series(date,date) and generate_series(date,date,integer)
Date
Msg-id 20160221214220.GA15621@msg.df7cb.de
Whole thread Raw
In response to Re: Add generate_series(date,date) and generate_series(date,date,integer)  (David Fetter <david@fetter.org>)
Responses Re: Add generate_series(date,date) and generate_series(date,date,integer)
List pgsql-hackers
Re: David Fetter 2016-01-26 <20160126180011.GA16903@fetter.org>
> +1 for back-patching.  There's literally no case where an infinite
> input could be correct as the start or end of an interval for
> generate_series.

select * from generate_series(now(), 'infinity', '1 day') limit 10;

... seems pretty legit to me. If limit pushdown into SRFs happened to
work some day, it'd be a pity if the above query raised an error.

Christoph
-- 
cb@df7cb.de | http://www.df7cb.de/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Add some isolation tests for deadlock detection and resolution.
Next
From: Fabien COELHO
Date:
Subject: Re: checkpointer continuous flushing - V18