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

2022-01-10 Thread Tom Lane
I wrote: > Aleksander Alekseev 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 screwe

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

2022-01-10 Thread Tom Lane
Aleksander Alekseev writes: > Due to DST and also changes in local laws, there could be gaps in > local time [1]. Yup. > 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/da

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

2022-01-10 Thread Aleksander Alekseev
Hi hackers, Due to DST and also changes in local laws, there could be gaps in local time [1]. For instance, 1 second after "2011-03-27 01:59:59 MSK" goes "2011-03-27 03:00:00 MSK": ``` select (timestamptz '2011-03-27 01:59:59 MSK') at time zone 'MSK'; timezone - 2011-03