diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 7 | ||||
| -rw-r--r-- | doc/src/sgml/datetime.sgml | 41 |
2 files changed, 37 insertions, 11 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 5a8595332b5..ba2e4463ea2 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -9755,6 +9755,13 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx </tgroup> </table> + <para> + While most timezone abbreviations represent fixed offsets from UTC, + there are some that have historically varied in value + (see <xref linkend="datetime-config-files"> for more information). + In such cases this view presents their current meaning. + </para> + </sect1> <sect1 id="view-pg-timezone-names"> diff --git a/doc/src/sgml/datetime.sgml b/doc/src/sgml/datetime.sgml index ffd07151282..ef9139f9e38 100644 --- a/doc/src/sgml/datetime.sgml +++ b/doc/src/sgml/datetime.sgml @@ -384,20 +384,39 @@ <para> A <replaceable>zone_abbreviation</replaceable> is just the abbreviation - being defined. The <replaceable>offset</replaceable> is the equivalent - offset in seconds from UTC, positive being east from Greenwich and - negative being west. For example, -18000 would be five hours west - of Greenwich, or North American east coast standard time. <literal>D</> - indicates that the zone name represents local daylight-savings time rather - than standard time. Alternatively, a <replaceable>time_zone_name</> can - be given, in which case that time zone definition is consulted, and the - abbreviation's meaning in that zone is used. This alternative is - recommended only for abbreviations whose meaning has historically varied, - as looking up the meaning is noticeably more expensive than just using - a fixed integer value. + being defined. An <replaceable>offset</replaceable> is an integer giving + the equivalent offset in seconds from UTC, positive being east from + Greenwich and negative being west. For example, -18000 would be five + hours west of Greenwich, or North American east coast standard time. + <literal>D</> indicates that the zone name represents local + daylight-savings time rather than standard time. </para> <para> + Alternatively, a <replaceable>time_zone_name</> can be given, referencing + a zone name defined in the IANA timezone database. The zone's definition + is consulted to see whether the abbreviation is or has been in use in + that zone, and if so, the appropriate meaning is used — that is, + the meaning that was currently in use at the timestamp whose value is + being determined, or the meaning in use immediately before that if it + wasn't current at that time, or the oldest meaning if it was used only + after that time. This behavior is essential for dealing with + abbreviations whose meaning has historically varied. It is also allowed + to define an abbreviation in terms of a zone name in which that + abbreviation does not appear; then using the abbreviation is just + equivalent to writing out the zone name. + </para> + + <tip> + <para> + Using a simple integer <replaceable>offset</replaceable> is preferred + when defining an abbreviation whose offset from UTC has never changed, + as such abbreviations are much cheaper to process than those that + require consulting a time zone definition. + </para> + </tip> + + <para> The <literal>@INCLUDE</> syntax allows inclusion of another file in the <filename>.../share/timezonesets/</> directory. Inclusion can be nested, to a limited depth. |