postgres.git / summary / log / commit / refs

commit    8995eac6c42465c2e866d3670fdb63f7bfbbabc2
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Sat Mar 18 20:11:22 2023 +0000
First released in: 16.0, 11.20, 12.15, 13.11, 14.8, 15.3

    Doc: fix documentation example for bytea hex output format.
    
    Per report from rsindlin
    
    Discussion: https://postgr.es/m/167907221210.1803488.5939223864945604536@wrigleys.postgresql.org


 doc/src/sgml/datatype.sgml | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index 0258b192e0e..a903dcc3216 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1480,7 +1480,12 @@ SELECT b, char_length(b) FROM test2;
    <para>
     Example:
 <programlisting>
-SELECT '\xDEADBEEF';
+SET bytea_output = 'hex';
+
+SELECT '\xDEADBEEF'::bytea;
+   bytea
+------------
+ \xdeadbeef
 </programlisting>
    </para>
   </sect2>


[parent: 8b87e92919cd]