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

From Torsten Zühlsdorff
Subject Re: Add generate_series(date,date) and generate_series(date,date,integer)
Date
Msg-id 56A87AC3.2070802@toco-domains.de
Whole thread Raw
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)  (David Steele <david@pgmasters.net>)
List pgsql-hackers
On 26.01.2016 13:53, Michael Paquier 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?

Looks fine to me.

(Minor mention: is there no newline needed between the tests?)

Greetings,
Torsten



pgsql-hackers by date:

Previous
From: Yury Zhuravlev
Date:
Subject: Re: Proposal:Use PGDLLEXPORT for libpq
Next
From: Michael Paquier
Date:
Subject: Re: Proposal:Use PGDLLEXPORT for libpq