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 | c05ef567d694ad9c51830991919b35ad993a59ad (patch) | |
| tree | 3182f1f24e27e0ad1eeac4bed9c86ce7249378a0 | |
| parent | bde7d6d79464c453ddafd18c5f4e808c17c4f04f (diff) | |
| download | postgresql-c05ef567d694ad9c51830991919b35ad993a59ad.tar.gz postgresql-c05ef567d694ad9c51830991919b35ad993a59ad.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 6b941c3584c..39c322ef4a9 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -5988,15 +5988,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> |