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

From Corey Huinker
Subject Re: Add generate_series(date,date) and generate_series(date,date,integer)
Date
Msg-id CADkLM=dZV_4W2VZuOzkS5cUKESzmNFUvtvFizXzYrVVedVUsyQ@mail.gmail.com
Whole thread
In response to Re: Add generate_series(date,date) and generate_series(date,date,integer)  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Add generate_series(date,date) and generate_series(date,date,integer)
List pgsql-hackers
On Tue, Jan 26, 2016 at 7:53 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Tue, Jan 26, 2016 at 7:00 PM, Torsten Zuehlsdorff
<mailinglists@toco-domains.de> wrote:
>
> On 26.01.2016 07:52, Simon Riggs wrote:
>
>>> Imagine for example a script that in some rare cases passes happens to
>>> pass infinity into generate_series() - in that case I'd much rather error
>>> out than wait till the end of the universe.
>>>
>>> So +1 from me to checking for infinity.
>>>
>>
>> +1
>>
>> ERROR infinite result sets are not supported, yet
>
>
> Maybe we should skip the "yet". Or do we really plan to support them in
> (infinite) future? ;)
>
> +1 from me to check infinity also.

Something like the patch attached would be fine? This wins a backpatch
because the query continuously running eats memory, no?
--
Michael


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


I'll modify my generate_series_date to give similar errors.

I have no opinion on backpatch.

+1 for flippant references to infinity.

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Proposal:Use PGDLLEXPORT for libpq
Next
From: David Fetter
Date:
Subject: Re: Add generate_series(date,date) and generate_series(date,date,integer)