summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane2023-03-18 20:11:22 +0000
committerTom Lane2023-03-18 20:11:54 +0000
commit4af259543b1581deeaedd6a983223d44b2db98b7 (patch)
treeba37101e8ecf010eac79e187fd99931c33caae87
parent012ffb365a05694e392bf96c8363d119bd19534c (diff)
Doc: fix documentation example for bytea hex output format.
Per report from rsindlin Discussion: https://postgr.es/m/167907221210.1803488.5939223864945604536@wrigleys.postgresql.org
-rw-r--r--doc/src/sgml/datatype.sgml7
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml
index bc48006505e..05554202502 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1356,7 +1356,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>