aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2023-03-18 16:11:22 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2023-03-18 16:11:45 -0400
commitd28f441d3232ee5b5c3d0c8505618c8696f5db72 (patch)
treecb4863db4702d1e9ec96dfd802c8d1f2f65e7294
parent7e7c5b683985c85fb990c4d49ab960cbc83434b4 (diff)
downloadpostgresql-d28f441d3232ee5b5c3d0c8505618c8696f5db72.tar.gz
postgresql-d28f441d3232ee5b5c3d0c8505618c8696f5db72.zip
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 2c2a6333adf..35f371ccca9 100644
--- a/doc/src/sgml/datatype.sgml
+++ b/doc/src/sgml/datatype.sgml
@@ -1395,7 +1395,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>