postgres.git / summary / log / commit / refs

commit    8f2799c993316a3dc436e231630b670a1ebf1fbb
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Mon Feb 20 15:05:01 2017 +0000
First released in: 10.0, 9.2.21, 9.3.17, 9.4.12, 9.5.7, 9.6.3

    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.


 doc/src/sgml/func.sgml | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index b4cc240c2cf..90fa6e99924 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -5740,15 +5740,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>


[parent: 045462960f7c]