diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2023-03-18 14:12:14 -0400 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2023-03-18 14:12:16 -0400 |
commit | 75bd846b68b09f33a57d9de96064ded4d392ca05 (patch) | |
tree | 3d5d6df0256c26817c96a0ce6102625523aef6f2 /src/backend/access/gist/gist.c | |
parent | 0e681cf0390ddd720424cd134a2c42dffc2934fd (diff) | |
download | postgresql-75bd846b68b09f33a57d9de96064ded4d392ca05.tar.gz |
Add functions to do timestamptz arithmetic in a non-default timezone.
Add versions of timestamptz + interval, timestamptz - interval, and
generate_series(timestamptz, ...) in which a timezone can be specified
explicitly instead of defaulting to the TimeZone GUC setting.
The new functions for the first two are named date_add and
date_subtract. This might seem too generic, but we could use
overloading to add additional variants if that seems useful.
Along the way, improve the docs' pretty inadequate explanation
of how timestamptz +- interval works.
Przemysław Sztoch and Gurjeet Singh; cosmetic changes and most of
the docs work by me
Discussion: https://postgr.es/m/01a84551-48dd-1359-bf7e-f6b0203a6bd0@sztoch.pl
Diffstat (limited to 'src/backend/access/gist/gist.c')
0 files changed, 0 insertions, 0 deletions