diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-08-31 20:27:27 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-08-31 20:27:27 -0400 |
| commit | a009cb3141e35f07791510c13992b087dc835467 (patch) | |
| tree | 18769daccfaa661bb3b7a22e3c7426949c1b6360 | |
| parent | 62c49fca1330954a678d1d74e2a7883eb950fcff (diff) | |
| download | postgresql-a009cb3141e35f07791510c13992b087dc835467.tar.gz postgresql-a009cb3141e35f07791510c13992b087dc835467.zip | |
doc: mention that SET TIME ZONE often needs to be quoted
Also mention that time zone abbreviations are not supported.
Reported-by: philippe.godfrin@nov.com
Discussion: https://postgr.es/m/163888728952.1269.5167822676466793158@wrigleys.postgresql.org
Backpatch-through: 10
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 5878c61f9b7..5459b295259 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -22,7 +22,7 @@ PostgreSQL documentation <refsynopsisdiv> <synopsis> SET [ SESSION | LOCAL ] <replaceable class="parameter">configuration_parameter</replaceable> { TO | = } { <replaceable class="parameter">value</replaceable> | '<replaceable class="parameter">value</replaceable>' | DEFAULT } -SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="parameter">timezone</replaceable> | LOCAL | DEFAULT } +SET [ SESSION | LOCAL ] TIME ZONE { <replaceable class="parameter">value</replaceable> | '<replaceable class="parameter">value</replaceable>' | LOCAL | DEFAULT } </synopsis> </refsynopsisdiv> @@ -192,8 +192,8 @@ SELECT setseed(<replaceable>value</replaceable>); <varlistentry> <term><literal>TIME ZONE</literal></term> <listitem> - <para><literal>SET TIME ZONE <replaceable>value</replaceable></literal> is an alias - for <literal>SET timezone TO <replaceable>value</replaceable></literal>. The + <para><literal>SET TIME ZONE '<replaceable>value</replaceable>'</literal> is an alias + for <literal>SET timezone TO '<replaceable>value</replaceable>'</literal>. The syntax <literal>SET TIME ZONE</literal> allows special syntax for the time zone specification. Here are examples of valid values: @@ -254,7 +254,8 @@ SELECT setseed(<replaceable>value</replaceable>); </para> <para> - See <xref linkend="datatype-timezones"/> for more information + Time zone abbreviations are not supported by <command>SET</command>; + see <xref linkend="datatype-timezones"/> for more information about time zones. </para> </listitem> |