Feature or bug: getting "Inf"::timestamp[tz] by "regular" value
От | Vitaly Burovoy |
---|---|
Тема | Feature or bug: getting "Inf"::timestamp[tz] by "regular" value |
Дата | |
Msg-id | CAKOSWNmLjs_2EyS4z_bDkp=RfU8s2M2P8joZVt18h+wfszWz7A@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Feature or bug: getting "Inf"::timestamp[tz] by "regular" value
|
Список | pgsql-hackers |
Hackers! I'm writing another patch for timestamps and while I tried to cover corner-cases I found out there is an ability to get "Infinity"::timestamptz via defining it by a specific (but not "Infinity") value: postgres=# SELECT '294277-01-09 04:00:54.775806+00'::timestamptz; -- OK timestamptz ---------------------------------294277-01-09 04:00:54.775806+00 (1 row) postgres=# SELECT '294277-01-09 04:00:54.775807+00'::timestamptz; -- Inf???timestamptz -------------infinity (1 row) postgres=# SELECT '294277-01-09 04:00:54.775808+00'::timestamptz; -- Higher values give an error ERROR: timestamp out of range: "294277-01-09 04:00:54.775808+00" LINE 1: SELECT '294277-01-09 04:00:54.775808+00'::timestamptz; ^ I could not find a way to get "-Infinity" by similar way. Is it feature or a bug? Does it worth to insert a check for that special case to raise an exception "timestamp out of range"? -- Best regards, Vitaly Burovoy
В списке pgsql-hackers по дате отправления: