Re: Parse CE and BCE in dates and times

On Mon, Jun 13, 2022 at 09:11:56AM +0200, Erik Rijkers wrote:
> 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?

It's not, and thanks for looking at this. Will check to see what's
going on here.

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate