From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: kiminoneko@163.com
Subject: BUG #18303: I found a description error about the maximum value of the interval type in the official documentati
Date: Fri, 19 Jan 2024 02:24:18 +0000
Message-ID: <18303-878bdfea939be3c3@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18303
Logged by: Ji XiaoBo
Email address: kiminoneko@163.com
PostgreSQL version: 15.1
Operating system: CentOS-7-x86_64
Description:
I found a description error about the maximum value of the interval type in
the official documentation. According to the official documentation, the
minimum value is -178,000,000 years, and the maximum value is 178,000,000
years. However, based on my actual testing, I found that the maximum value
is around 178,956,970.6 years. For example, I can successfully execute the
SQL statement "select interval '178956970.6 year'" but executing "select
interval '178956970.7 year'" will prompt "interval field value out of
range". I tested both versions 12.4 and 15.1 and got the same result.
Please tell me if this is a document description error and if it needs to
be modified, thanks!
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, kiminoneko@163.com
Subject: Re: BUG #18303: I found a description error about the maximum value of the interval type in the official documentati
In-Reply-To: <18303-878bdfea939be3c3@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