Re: Patch: shouldn't timezone(text, timestamp[tz]) be STABLE?

Aleksander Alekseev <aleksander@timescale.com>

View thread View on postgr.es

From: Aleksander Alekseev <aleksander@timescale.com>

To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Cc: Tom Lane <tgl@sss.pgh.pa.us>

Date: 2021-09-01T09:19:47Z

Lists: pgsql-hackers

Attachments

v3-0001-timezone_volatility.patch (application/octet-stream) patch v3-0001

Hi Tom,

> No, because date_trunc depends on the current timezone setting,
> or at least its stable variants do.

Once again, many thanks for your answers!

> I wasn't excited enough about it personally to change it, and I'm
> still not --- but if you want to, send a patch.

Here is the patch.

-- 
Best regards,
Aleksander Alekseev

Commits

Fix actively-misleading comments about the contents of struct pg_tm.
- 89dba59590fd 15.0 landed
Fix bogus timetz_zone() results for DYNTZ abbreviations.
- eb3c8d24808a 12.9 landed
- d8a266c5e1bd 13.5 landed
- b28c862a6c11 10.19 landed
- 90b4647f63da 11.14 landed
- 599c73a91a04 14.0 landed
- 5907c3818c43 9.6.24 landed
Make timetz_zone() stable, and correct a bug for DYNTZ abbreviations.
- 388e71af880d 15.0 landed