Re: Using make_timestamp() to create a BC value

[Bryn Llewellyn <bryn@xxxxxxxxxxxx>]

tgl@xxxxxxxxxxxxx wrote:

Bryn wrote:

But this invocation makes the assertion fail:

call assert_make_ts_from_extracted_fields_from_ts_ok('0001-01-01 00:00:00 BC');
The 22008 error is reported thus:
date field value out of range: -1-01-01

As of v14, make_timestamp[tz] will accept negative year values as meaning BC. Before that, they threw errors.

Ah… that's excellent news. Thanks for the lightening fast response, Tom. Thanks, too, to Adrian who passed on similar news, and this link:

www.postgresql.org/docs/current/release-14.html#id-1.11.6.5.3

I did my test using PostgreSQL 13.4. Forgive me for not mentioning this.