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)
Re: Add generate_series(date,date) and generate_series(date,date,integer) |
Список | 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 по дате отправления: