pgsql: Add support for AT LOCAL
От | Michael Paquier |
---|---|
Тема | pgsql: Add support for AT LOCAL |
Дата | |
Msg-id | E1qr9N5-000Hdo-Gg@gemulon.postgresql.org обсуждение исходный текст |
Список | 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(-)
В списке pgsql-committers по дате отправления: