Module name: pgsql-server
Changes by: momjian(at)postgresql(dot)org 03/03/20 01:03:01
Attached is a patch that limits the range tested by horology to
what is capable using integer-datatime timestamps. It does attempt
to exercise the maximum allowable timestamp range.
Also is a small error check when converting a timestamp from external
to internal format that prevents out of range timestamps from being
Added range check to prevent out of range timestamps
from being used.
Limited range of timestamps being checked to
Jan 1, 4713 BC to Dec 31, 294276
In creating this patch, I have seen some definite problems with integer
timestamps and how they react when used near their limits. For example,
the following statement gives the correct result:
SELECT timestamp without time zone 'Jan 1, 4713 BC'
+ interval '109203489 days' AS "Dec 31, 294276";
However, this statement which is the logical inverse of the above
gives incorrect results:
SELECT timestamp without time zone '12/31/294276'
- timestamp without time zone 'Jan 1, 4713 BC' AS "109203489 Days";
pgsql-committers by date
|Next:||From: Bruce Momjian - CVS||Date: 2003-03-20 06:23:30|
|Subject: pgsql-server/ oc/src/sgml/libpq.sgml rc/interf ...|
|Previous:||From: Bruce Momjian - CVS||Date: 2003-03-20 06:00:12|
|Subject: pgsql-server/src/bin/psql common.c common.h co ...|