git.postgresql.org Git - users/gsingh/postgres.git/commit

projects / users / gsingh / postgres.git / commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 29 Sep 2020 17:48:06 +0000 (13:48 -0400)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Tue, 29 Sep 2020 17:48:06 +0000 (13:48 -0400)
commit	a094c8ff53523e88ff9dd28ad467618039e27b58
tree	74e9cb9f1ae1702f2d865481aa684b952f0375a4	tree
parent	a6b1f5365d58356b5d42829e9cd89a6c725d7a0a	commit \| diff

Fix make_timestamp[tz] to accept negative years as meaning BC.

Previously we threw an error. But make_date already allowed the case,
so it is inconsistent as well as unhelpful for make_timestamp not to.

Both functions continue to reject year zero.

Code and test fixes by Peter Eisentraut, doc changes by me

Discussion: https://postgr.es/m/13c0992c-f15a-a0ca-d839-91d3efd965d9@2ndquadrant.com

Postgres clone for personal branches

RSS Atom

doc/src/sgml/func.sgml		diff \| blob \| blame \| history
src/backend/utils/adt/timestamp.c		diff \| blob \| blame \| history
src/test/regress/expected/date.out		diff \| blob \| blame \| history
src/test/regress/expected/timestamp.out		diff \| blob \| blame \| history
src/test/regress/sql/date.sql		diff \| blob \| blame \| history
src/test/regress/sql/timestamp.sql		diff \| blob \| blame \| history