Re: Undocumented behavior of timezone(zone, timestamp) for impossible timestamptz's

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Aleksander Alekseev <aleksander(at)timescale(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Undocumented behavior of timezone(zone, timestamp) for impossible timestamptz's
Date: 2022-01-10 15:29:12
Message-ID: 2191355.1641828552@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> Aleksander Alekseev <aleksander(at)timescale(dot)com> writes:
>> 1. Should this behavior be documented in the 9.9.4. AT TIME ZONE
>> section or maybe it's documented elsewhere and I just missed it?

> https://www.postgresql.org/docs/current/datetime-invalid-input.html

... and reading that again, I realize that I screwed up the
fall-back example :-(. 2:30 is not ambiguous; I should have
demonstrated the behavior for, say, 1:30. Will fix.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2022-01-10 15:42:00 Re: pg_upgrade verbosity when redirecting output to log file
Previous Message Juan José Santamaría Flecha 2022-01-10 15:26:38 Re: Fix vcregress plpython3 warning