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/include | |
| parent | 0e681cf0390ddd720424cd134a2c42dffc2934fd (diff) | |
| download | postgresql-75bd846b68b09f33a57d9de96064ded4d392ca05.tar.gz postgresql-75bd846b68b09f33a57d9de96064ded4d392ca05.zip | |
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/include')
| -rw-r--r-- | src/include/catalog/catversion.h | 2 | ||||
| -rw-r--r-- | src/include/catalog/pg_proc.dat | 21 |
2 files changed, 22 insertions, 1 deletions
diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h index b2eed22d46c..e94528a7c71 100644 --- a/src/include/catalog/catversion.h +++ b/src/include/catalog/catversion.h @@ -57,6 +57,6 @@ */ /* yyyymmddN */ -#define CATALOG_VERSION_NO 202303151 +#define CATALOG_VERSION_NO 202303181 #endif diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat index fbc4aade494..5cf87aeb2c4 100644 --- a/src/include/catalog/pg_proc.dat +++ b/src/include/catalog/pg_proc.dat @@ -2426,10 +2426,26 @@ proname => 'timestamptz_pl_interval', provolatile => 's', prorettype => 'timestamptz', proargtypes => 'timestamptz interval', prosrc => 'timestamptz_pl_interval' }, +{ oid => '8800', descr => 'add interval to timestamp with time zone', + proname => 'date_add', provolatile => 's', prorettype => 'timestamptz', + proargtypes => 'timestamptz interval', prosrc => 'timestamptz_pl_interval' }, +{ oid => '8801', + descr => 'add interval to timestamp with time zone in specified time zone', + proname => 'date_add', prorettype => 'timestamptz', + proargtypes => 'timestamptz interval text', + prosrc => 'timestamptz_pl_interval_at_zone' }, { oid => '1190', proname => 'timestamptz_mi_interval', provolatile => 's', prorettype => 'timestamptz', proargtypes => 'timestamptz interval', prosrc => 'timestamptz_mi_interval' }, +{ oid => '8802', descr => 'subtract interval from timestamp with time zone', + proname => 'date_subtract', provolatile => 's', prorettype => 'timestamptz', + proargtypes => 'timestamptz interval', prosrc => 'timestamptz_mi_interval' }, +{ oid => '8803', + descr => 'subtract interval from timestamp with time zone in specified time zone', + proname => 'date_subtract', prorettype => 'timestamptz', + proargtypes => 'timestamptz interval text', + prosrc => 'timestamptz_mi_interval_at_zone' }, { oid => '1195', descr => 'smaller of two', proname => 'timestamptz_smaller', prorettype => 'timestamptz', proargtypes => 'timestamptz timestamptz', prosrc => 'timestamp_smaller' }, @@ -8252,6 +8268,11 @@ provolatile => 's', prorettype => 'timestamptz', proargtypes => 'timestamptz timestamptz interval', prosrc => 'generate_series_timestamptz' }, +{ oid => '8804', descr => 'non-persistent series generator', + proname => 'generate_series', prorows => '1000', proretset => 't', + prorettype => 'timestamptz', + proargtypes => 'timestamptz timestamptz interval text', + prosrc => 'generate_series_timestamptz_at_zone' }, # boolean aggregates { oid => '2515', descr => 'aggregate transition function', |