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 | da8cd8fbd9be96c5e48e059717a9ae6f4056466c (patch) | |
| tree | ba93068c60d3422c14c3b0ad5cc2691952e420c6 | |
| parent | 3563d5f23ef4e8826e82026cc976e9ad25c9af85 (diff) | |
| download | postgresql-da8cd8fbd9be96c5e48e059717a9ae6f4056466c.tar.gz postgresql-da8cd8fbd9be96c5e48e059717a9ae6f4056466c.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 22d0e3f6e49..9c384f1ac4a 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> @@ -190,8 +190,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: @@ -252,7 +252,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> |