Op 13-06-2022 om 07:51 schreef David Fetter:
Folks,
Please find attached a patch to do $Subject. As dates in a fair number
of fields of endeavor are expressed this way, it seems reasonable to
ensure tha we can parse them on input. Making it possible to use them
in output is a more invasive patch, and would involve changes to
to_date and similar that would require careful consideration.
Hi David,
I find some unexpected results:
# select '112-04-30 BC'::date;
date
---------------
0112-04-30 BC
(1 row)
but the same with the ' BCE' suffix seems broken:
# select '112-04-30 BCE'::date;
ERROR: invalid input syntax for type date: "112-04-30 BCE"
LINE 1: select '112-04-30 BCE'::date;
The same goes for '112-04-30 AD' (works) and its CE version (errors out).
Or is this as expected?
Erik Rijkers
Best,
David.
