postgres.git / summary / log / commit / refs

commit    71672056784f7b29e7592f9a9a413f9cd8fde5cf
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 d065b8be1e1..9a15fe73a4d 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -4198,7 +4198,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: ce9bd103e0e3]