BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone
Дата
Msg-id 16571-eb7501598de78c8a@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16571
Logged by:          osdba
Email address:      mailtch@163.com
PostgreSQL version: 13beta2
Operating system:   all
Description:

In Document(https://www.postgresql.org/docs/current/datatype-datetime.html),
"time with time zone" range is:  00:00:00+1459 to 24:00:00-1459

but you can input:

osdba=# select '00:00:00+1559'::time with time zone;
     timetz
----------------
 00:00:00+15:59
(1 row)

osdba=# select '24:00:00-1559'::time with time zone;
     timetz
----------------
 24:00:00-15:59
(1 row)

you can input range is :
00:00:00+1559 to 24:00:00-1559
not the "00:00:00+1459 to 24:00:00-1459"

Document error or this type bug?

all version postgresql have this strange phenomenon.


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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16570: Collation not working
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone