postgres.git / summary / log / commit / refs

commit    851a5869cd27bee61e08c277f22bc47b033aaaef
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 d1bf8e32fcf..ac409740a9e 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -3788,7 +3788,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: 5d17c0c02f30]