From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Add support for AT LOCAL
Date: Fri, 13 Oct 2023 04:01:55 +0000
Message-ID: <E1qr9N5-000Hdo-Gg@gemulon.postgresql.org> (raw)
Add support for AT LOCAL
When converting a timestamp to/from with/without time zone, the SQL
Standard specifies an AT LOCAL variant of AT TIME ZONE which uses the
session's time zone. This includes three system functions able to do
the work in the same way as the existing flavors for AT TIME ZONE,
except that these need to be marked as stable as they depend on the
session's TimeZone GUC.
Bump catalog version.
Author: Vik Fearing
Reviewed-by: Laurenz Albe, Cary Huang, Michael Paquier
Discussion: https://postgr.es/m/8e25dec4-5667-c1a5-6581-167d710c2182@postgresfriends.org
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/97957fdbaa429c7c582d4753b108cb1e23e1b28a
Modified Files
--------------
doc/src/sgml/func.sgml | 97 ++++++++++++++++++++++++++++++-
src/backend/parser/gram.y | 7 +++
src/backend/utils/adt/date.c | 15 +++++
src/backend/utils/adt/ruleutils.c | 10 ++++
src/backend/utils/adt/timestamp.c | 20 +++++++
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.dat | 9 +++
src/test/regress/expected/timestamptz.out | 56 ++++++++++++++++++
src/test/regress/expected/timetz.out | 42 +++++++++++++
src/test/regress/sql/timestamptz.sql | 23 ++++++++
src/test/regress/sql/timetz.sql | 17 ++++++
11 files changed, 294 insertions(+), 4 deletions(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Add support for AT LOCAL
In-Reply-To: <E1qr9N5-000Hdo-Gg@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox