From 082befb5162920d64ef4c1e905489a625dff2d5a Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 5 Sep 2011 15:38:00 -0400 Subject: [PATCH] Add mention that UTC really means UT1. Backpatch to 9.1. --- doc/src/sgml/catalogs.sgml | 4 +++- doc/src/sgml/func.sgml | 4 +++- 2 files changed, 6 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 7d5a9efa11..32a51dbd8c 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -8225,7 +8225,9 @@ The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, - and daylight-savings status. + and daylight-savings status. (Technically, + PostgreSQL uses UT1 rather + than UTC because leap seconds are not handled.) Unlike the abbreviations shown in pg_timezone_abbrevs, many of these names imply a set of daylight-savings transition date rules. Therefore, the associated information changes across local DST diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 95da31c8d2..43c0ee0122 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6898,7 +6898,9 @@ SELECT EXTRACT(SECOND FROM TIME '17:12:28.5'); The time zone offset from UTC, measured in seconds. Positive values correspond to time zones east of UTC, negative values to - zones west of UTC. + zones west of UTC. (Technically, + PostgreSQL uses UT1 because + leap seconds are not handled.) -- 2.40.0