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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Add generate_series(date,date) and generate_series(date,date,integer)
Дата
Msg-id 5994.1453702944@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Add generate_series(date,date) and generate_series(date,date,integer)  (Michael Paquier <michael.paquier@gmail.com>)
Ответы 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)  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers
Michael Paquier <michael.paquier@gmail.com> writes:
> On Mon, Jan 25, 2016 at 3:00 PM, Corey Huinker <corey.huinker@gmail.com> wrote:
>> One thing I discovered in doing this patch is that if you do a timestamp
>> generate_series involving infinity....it tries to do it. I didn't wait to
>> see if it finished.

> Well, I would think that this is a bug that we had better address and
> backpatch. It does not make much sense to use infinity for timestamps,
> but letting it run infinitely is not good either.

Meh.  Where would you cut it off?  AD 10000000000?  A few zeroes either
way doesn't really make much difference.

If it didn't respond to SIGINT, that would be an issue, but otherwise
this doesn't seem much more exciting than any other way to create a
query that will run longer than you want to wait.
        regards, tom lane



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Add generate_series(date,date) and generate_series(date,date,integer)
Следующее
От: Dilip Kumar
Дата:
Сообщение: Re: Relation extension scalability