Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Fix documentation of to_char/to_timestamp TZ, tz, OF formatting patterns.
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 20 Feb 2017 15:05:01 +0000 (10:05 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 20 Feb 2017 15:05:01 +0000 (10:05 -0500)
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.

doc/src/sgml/func.sgml

index 2d11f5cc63921ea442e5adf61eff82c27e2e60e3..02dcd064374fb4e67e57f4bb8cfcfb08d0ef0009 100644 (file)
@@ -5723,11 +5723,13 @@ 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>
       </tbody>
      </tgroup>