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!
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 |