From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: mailtch@163.com
Subject: BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone
Date: Mon, 03 Aug 2020 07:26:09 +0000
Message-ID: <16571-eb7501598de78c8a@postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, mailtch@163.com
Subject: Re: BUG #16571: "time with time zone" type can input '00:00:00+1559'::time with time zone
In-Reply-To: <16571-eb7501598de78c8a@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox