pgsql: Add support for AT LOCAL

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add support for AT LOCAL
Date: 2023-10-13 04:01:55
Message-ID: E1qr9N5-000Hdo-Gg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2023-10-13 05:31:09 pgsql: psql: Add completion support for AT [ LOCAL | TIME ZONE ]
Previous Message Thomas Munro 2023-10-13 03:50:49 pgsql: Add wait events for checkpoint delay mechanism.