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

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Add generate_series(date,date) and generate_series(date,date,integer)
Дата
Msg-id CAB7nPqTGLZJH4P+RMP_xJGEwWXSGvUL7crUZEK+tOkMZeq0tKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add generate_series(date,date) and generate_series(date,date,integer)  (Torsten Zuehlsdorff <mailinglists@toco-domains.de>)
Ответы Re: Add generate_series(date,date) and generate_series(date,date,integer)  (Corey Huinker <corey.huinker@gmail.com>)
Re: Add generate_series(date,date) and generate_series(date,date,integer)  (David Fetter <david@fetter.org>)
Re: Add generate_series(date,date) and generate_series(date,date,integer)  (Euler Taveira <euler@timbira.com.br>)
Re: Add generate_series(date,date) and generate_series(date,date,integer)  (Torsten Zühlsdorff <mailinglists@toco-domains.de>)
Список pgsql-hackers
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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Improve tab completion for REFRESH MATERIALIZED VIEW
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: pgbench - allow backslash-continuations in custom scripts