| 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: | Whole Thread | Raw Message | 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 |