BUG #18303: I found a description error about the maximum value of the interval type in the official documentati

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: kiminoneko(at)163(dot)com
Subject: BUG #18303: I found a description error about the maximum value of the interval type in the official documentati
Date: 2024-01-19 02:24:18
Message-ID: 18303-878bdfea939be3c3@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18303
Logged by: Ji XiaoBo
Email address: kiminoneko(at)163(dot)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!

Browse pgsql-bugs by date

  From Date Subject
Next Message Emeric SOULENQ 2024-01-19 08:13:43 Re: BUG #18299: yum.postgresql.org/keys website is down (404 error) and can't download keys
Previous Message Devrim Gündüz 2024-01-18 23:59:50 Re: BUG #18289: postgresql14-devel-14.10-2PGDG.rhel8.x86_64.rpm Contains invalid cLang option in Makefile.global