diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2017-02-20 10:05:00 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2017-02-20 10:05:00 -0500 |
| commit | 10257fc5ff74487a46594bd8c8c041878f409c17 (patch) | |
| tree | d65331a48d904de6b40fed6c5d49685406aafacf | |
| parent | 090f21bbad98001979da8589e9647a1d49bce4ee (diff) | |
| download | postgresql-10257fc5ff74487a46594bd8c8c041878f409c17.tar.gz postgresql-10257fc5ff74487a46594bd8c8c041878f409c17.zip | |
Fix documentation of to_char/to_timestamp TZ, tz, OF formatting patterns.
These are only supported in to_char, not in the other direction, but the
documentation failed to mention that. Also, describe TZ/tz as printing the
time zone "abbreviation", not "name", because what they print is elsewhere
referred to that way. Per bug #14558.
| -rw-r--r-- | doc/src/sgml/func.sgml | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index d7738b18b7a..1c8202c257c 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -6062,15 +6062,18 @@ SELECT regexp_match('abc01234xyz', '(?:(.*?)(\d+)(.*)){1,1}'); </row> <row> <entry><literal>TZ</literal></entry> - <entry>upper case time-zone name</entry> + <entry>upper case time-zone abbreviation + (only supported in <function>to_char</>)</entry> </row> <row> <entry><literal>tz</literal></entry> - <entry>lower case time-zone name</entry> + <entry>lower case time-zone abbreviation + (only supported in <function>to_char</>)</entry> </row> <row> <entry><literal>OF</literal></entry> - <entry>time-zone offset</entry> + <entry>time-zone offset from UTC + (only supported in <function>to_char</>)</entry> </row> </tbody> </tgroup> |