diff options
| author | Michael Paquier <michael@paquier.xyz> | 2023-10-13 10:55:25 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2023-10-13 10:55:25 +0900 |
| commit | 7e1f544827ec843918f189765863269ff3a1c77e (patch) | |
| tree | 4d1283a8382151f87fcaaf2598bb975cd5282b00 | |
| parent | df9a3d4e99941f66f7a247eb01a48c1c2630625d (diff) | |
| download | postgresql-7e1f544827ec843918f189765863269ff3a1c77e.tar.gz postgresql-7e1f544827ec843918f189765863269ff3a1c77e.zip | |
doc: Mention timezone(zone, time) in section for AT TIME ZONE
timezone(zone, timestamp) is already mentioned as an equivalent of the
two first patterns in the table describing the AT TIME ZONE variants,
but did not mention the third case about "time" and its equivalent as an
SQL function, so let's be consistent here.
Extracted from a larger patch by the same author.
Author: Vik Fearing
Discussion: https://postgr.es/m/8e25dec4-5667-c1a5-6581-167d710c2182@postgresfriends.org
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index f1ad64c3d69..0769824e46b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10738,6 +10738,13 @@ SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Asia/Tokyo' AT TIME ZONE 'A <literal><replaceable>timestamp</replaceable> AT TIME ZONE <replaceable>zone</replaceable></literal>. </para> + + <para> + The function <literal><function>timezone</function>(<replaceable>zone</replaceable>, + <replaceable>time</replaceable>)</literal> is equivalent to the SQL-conforming construct + <literal><replaceable>time</replaceable> AT TIME ZONE + <replaceable>zone</replaceable></literal>. + </para> </sect2> <sect2 id="functions-datetime-current"> |