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 | 09e9aab4419e585d07360be3799a23a1d57c8a9c (patch) | |
| tree | fc118f026a800926cb68ecdbc52dcda8bce2fa39 /doc/src | |
| parent | cfb022dc9edea701f3e4d1ca31105135e196ad99 (diff) | |
| download | postgresql-09e9aab4419e585d07360be3799a23a1d57c8a9c.tar.gz postgresql-09e9aab4419e585d07360be3799a23a1d57c8a9c.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.
Diffstat (limited to 'doc/src')
| -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 89c75b7bee4..e0b1b01e64d 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -5746,15 +5746,18 @@ SELECT regexp_matches('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> |