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 | 4eab0181a0e1a72d4a3dd524210c3384bd6396e9 (patch) | |
| tree | 5ffddfdeb97c2eaae285f5693325720c8c52d884 /doc/src | |
| parent | 92557ac314e52c248d0a864c5e4b6088cddd8687 (diff) | |
| download | postgresql-4eab0181a0e1a72d4a3dd524210c3384bd6396e9.tar.gz postgresql-4eab0181a0e1a72d4a3dd524210c3384bd6396e9.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
Diffstat (limited to 'doc/src')
| -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 c4aab56a2d3..9a7b387b29f 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> |