BUG #15529: interval max value '178000000 years' in doc is not exact. It should 178956970.

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: 369358123(at)qq(dot)com
Subject: BUG #15529: interval max value '178000000 years' in doc is not exact. It should 178956970.
Date: 2018-11-30 10:17:35
Message-ID: 15529-fbe275849adcdc4b@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: 15529
Logged by: wang yakun
Email address: 369358123(at)qq(dot)com
PostgreSQL version: 11.0
Operating system: Linux
Description:

you wrote:

interval:
Low Value: -178000000 years
High Value: 178000000 years

in 'Table 8.9. Date/Time Types' in postgresql 11 documention.
However, I can execute this sql:

postgres=# select interval '178000001' year;
interval
-----------------
178000001 years
(1 row)

In other words, max value is not 178000000.
****************************************************
I test the exact value is 178956970:

postgres=# select interval '178956970' year;
interval
-----------------
178956970 years
(1 row)

postgres=# select interval '178956971' year;
ERROR: interval out of range
LINE 1: select interval '178956971' year;
^
So, you should wrote 178956970 in postgresql 11 documention.

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2018-11-30 11:46:01 BUG #15530: unable restore index on function from earthdistance contrib
Previous Message PG Bug reporting form 2018-11-30 08:16:06 BUG #15528: on v11.0 version still get error "ERROR: catalog is missing 1 attribute(s) for relid 6855092"