postgres.git / summary / log / commit / refs

commit    1b940d102438d3b2722d84f98068bc513186de59
Author:   Daniel Gustafsson <dgustafsson@postgresql.org>
Date:     Wed Sep 23 12:07:25 2026 +0000

    doc:  Fix example output for format()
    
    The example output for format() didn't show the actual output
    generated for the example query.  Backpatch to all supported
    branches.
    
    Author: shihao zhong <zhong950419@gmail.com>
    Reported-by: y.saburov@gmail.com
    Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>
    Discussion: https://postgr.es/m/178979714249.1241.1230833804069549466@wrigleys.postgresql.org
    Backpatch-through: 14


 doc/src/sgml/func/func-string.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/func/func-string.sgml b/doc/src/sgml/func/func-string.sgml
index 0786573d7be..21a7d0203f9 100644
--- a/doc/src/sgml/func/func-string.sgml
+++ b/doc/src/sgml/func/func-string.sgml
@@ -1756,7 +1756,7 @@ SELECT format('INSERT INTO %I VALUES(%L)', 'Foo bar', E'O\'Reilly');
 <lineannotation>Result: </lineannotation><computeroutput>INSERT INTO "Foo bar" VALUES('O''Reilly')</computeroutput>
 
 SELECT format('INSERT INTO %I VALUES(%L)', 'locations', 'C:\Program Files');
-<lineannotation>Result: </lineannotation><computeroutput>INSERT INTO locations VALUES('C:\Program Files')</computeroutput>
+<lineannotation>Result: </lineannotation><computeroutput>INSERT INTO locations VALUES(E'C:\\Program Files')</computeroutput>
 </screen>
     </para>
 


[parent: fe1d5aeffda7]