Thanks, patch applied back to PG 11.
--------------------------------------------------------------------------- On Tue, Apr 11, 2023 at 09:54:11AM +0200, Laurenz Albe wrote: > The documentation in > https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING > says that > > "While the standard syntax for specifying string constants is usually > convenient, > it can be difficult to understand when the desired string contains many > single > quotes or backslashes, since each of those must be doubled." > > But this has been obsolete ever since version 9.1, when > "standard_conforming_strings" > started to default to "on". It has confused at least one reader: > https://dba.stackexchange.com/q/325850/176905 > > So I propose to remove the mention of backslashes there. > > Yours, > Laurenz Albe > From 282d2dae27524aef37cdafe02e4833894bf5892c Mon Sep 17 00:00:00 2001 > From: Laurenz Albe <laurenz.a...@cybertec.at> > Date: Tue, 11 Apr 2023 09:48:20 +0200 > Subject: [PATCH] Remove obsolete mention of backslashes as escapes > > Since version 9.1, standard_conforming_strings defaults to "on". > So the remark that backslashes must be doubled has been obsolete > for a long time and should be removed. It is more confusing than > helpful by now. > --- > doc/src/sgml/syntax.sgml | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > > diff --git a/doc/src/sgml/syntax.sgml b/doc/src/sgml/syntax.sgml > index 5668ab0143..3ba844057f 100644 > --- a/doc/src/sgml/syntax.sgml > +++ b/doc/src/sgml/syntax.sgml > @@ -555,7 +555,7 @@ U&'d!0061t!+000061' UESCAPE '!' > <para> > While the standard syntax for specifying string constants is usually > convenient, it can be difficult to understand when the desired string > - contains many single quotes or backslashes, since each of those must > + contains many single quotes, since each of those must > be doubled. To allow more readable queries in such situations, > <productname>PostgreSQL</productname> provides another way, called > <quote>dollar quoting</quote>, to write string constants. > -- > 2.39.2 > -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
