Skip site navigation (1) Skip section navigation (2)

pgsql: Update examples for string-related functions.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Update examples for string-related functions.
Date: 2011-07-07 23:36:14
Message-ID: E1Qey7C-0004CA-JC@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Update examples for string-related functions.

In the example for decode(), show the bytea result in hex format,
since that's now the default.  Use an E'' string in the example for
quote_literal(), so that it works regardless of the
standard_conforming_strings setting.  On the functions-for-binary-strings
page, leave the examples as-is for readability, but add a note pointing out
that they are shown in escape format.  Per comments from Thom Brown.

Also, improve the description for encode() and decode() a tad.

Backpatch to 9.0, where bytea_output was introduced.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c59b8ba6cd48e0fc0c1be8d86d4a19e7bf37d7e0

Modified Files
--------------
doc/src/sgml/func.sgml |   26 +++++++++++++++++---------
1 files changed, 17 insertions(+), 9 deletions(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2011-07-08 00:13:32
Subject: pgsql: Tag 9.1beta3.
Previous:From: Tom LaneDate: 2011-07-07 21:56:51
Subject: pgsql: Update 9.1 release notes to reflect commits through today.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group