postgres.git / summary / log / commit / refs

commit    4e547832bb70360ad7c3e87b2cfd494a06db06e7
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.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 3e63d4544b6..20803ceee64 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -3939,7 +3939,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: 9dc7554abe4c]