]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Implement precision support for timestamp and time, both with and without
authorThomas G. Lockhart <lockhart@fourpalms.org>
Wed, 3 Oct 2001 05:29:27 +0000 (05:29 +0000)
committerThomas G. Lockhart <lockhart@fourpalms.org>
Wed, 3 Oct 2001 05:29:27 +0000 (05:29 +0000)
commit3e1beda2cde3495f41290e1ece5d544525810214
tree25a07c51bba4a23b3fd4e02261064146bb7c884c
parenta51de40fb60c0679d1987c25a2d3e47689be98d5
Implement precision support for timestamp and time, both with and without
 time zones.
SQL99 spec requires a default of zero (round to seconds) which is set
 in gram.y as typmod is set in the parse tree. We *could* change to a
 default of either 6 (for internal compatibility with previous versions)
 or 2 (for external compatibility with previous versions).
Evaluate entries in pg_proc wrt the iscachable attribute for timestamp and
 other date/time types. Try to recognize cases where side effects like the
 current time zone setting may have an effect on results to decide whether
 something is cachable or not.
22 files changed:
src/backend/parser/analyze.c
src/backend/parser/gram.y
src/backend/parser/parse_coerce.c
src/backend/utils/adt/date.c
src/backend/utils/adt/datetime.c
src/backend/utils/adt/numeric.c
src/backend/utils/adt/timestamp.c
src/backend/utils/adt/varchar.c
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/utils/date.h
src/include/utils/timestamp.h
src/test/regress/expected/horology.out
src/test/regress/expected/time.out
src/test/regress/expected/timestamp.out
src/test/regress/expected/timestamptz.out
src/test/regress/expected/timetz.out
src/test/regress/sql/horology.sql
src/test/regress/sql/time.sql
src/test/regress/sql/timestamp.sql
src/test/regress/sql/timestamptz.sql
src/test/regress/sql/timetz.sql