Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pm8pZ-0000fo-BH for pgsql-docs@arkaria.postgresql.org; Tue, 11 Apr 2023 07:54:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pm8pX-00051k-O0 for pgsql-docs@arkaria.postgresql.org; Tue, 11 Apr 2023 07:54:19 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pm8pX-00051b-Bb for pgsql-docs@lists.postgresql.org; Tue, 11 Apr 2023 07:54:19 +0000 Received: from mail-wr1-x436.google.com ([2a00:1450:4864:20::436]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pm8pU-002C07-8B for pgsql-docs@lists.postgresql.org; Tue, 11 Apr 2023 07:54:18 +0000 Received: by mail-wr1-x436.google.com with SMTP id e22so6465732wra.6 for ; Tue, 11 Apr 2023 00:54:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; t=1681199654; h=mime-version:user-agent:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=cApbGYIJZ1WuQMJAdcIrJ9i6Ix1j1uys2muk8ojoVxY=; b=tRbbI+mwYbsdZHRgG2O1rH/TBFQX5/MaP+S98+ofMLSZ2gK4K8bEycRzVIzIhc7d0f FgF12kUl5WqkloYuYXYF2Eea/fwbQ5jxBXGAiL/V7A6+dB/D2XvrQ8tOitJ1/M03RxXX cirOGdgULN8V5HZtcyEonYUJujuRrUEfmQQUZVym24pN3LMY8Dez+ZEKhOgYuyHTHVPa yuX/kfkr7YkkW1EiAkWbtuhiV5M4XUAuwU9vTgV+93YUewhhmmQjK0YbTXPWMVK25iJ0 6NF00bVEWWYhUsy2BUfgix2xyzbmsgNheEhf3Ss+gzOekp8qKLyBBMBq7ikLIFPBe1my iOtQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1681199654; h=mime-version:user-agent:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=cApbGYIJZ1WuQMJAdcIrJ9i6Ix1j1uys2muk8ojoVxY=; b=FsGk1+reu+1fQER+J0mRbbarpVguHzqOULM01kZp4dSEMhx35TAfARFNxJZqxDv/eb qWUREMyxCKdzlYWa8UNgV+m+lGdUSeqZw62gKu1OdHIL543E/mjsrxULROeGB12FTXIW C+baZrtMSwOdEZfuqtD5vzlhzNyZZfwjNS1Q2cJ0QlQeEFmAmY3JNU7uuVekg9wbIKun VDk9AxRQhOScFR0Nr5HTv8Vze1yg+ofG5fho+bqgVFHSmwcDNXH4WzhptFgckX6xnAsz CxiAqfIepctLGMHPYlSjQQwT9v9K8NQRrdxTGfIX1sqjEO/kxsbdKKnBI65tR6VT+fjC VPTw== X-Gm-Message-State: AAQBX9ctbkjQwh2PdWEAmp+WTJezIL+4kejknXxHexJxhiPpcNLr9vFB TpPUGmd3L+dKcdZSxNvTfOT4csEJxjmu24ohq+c= X-Google-Smtp-Source: AKy350bRRydj658ao7L/ZB1jyNLjkK35mmK5CvT+cnhboC0oO7ToKfebfNnlmIupGCmmpMF1RwQznQ== X-Received: by 2002:a5d:5484:0:b0:2c7:1e16:57cf with SMTP id h4-20020a5d5484000000b002c71e1657cfmr7670694wrv.67.1681199652928; Tue, 11 Apr 2023 00:54:12 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:1d61:c942:4a41:32cc:c9bc]) by smtp.gmail.com with ESMTPSA id s6-20020a5d4ec6000000b002efb6e0c495sm9138676wrv.91.2023.04.11.00.54.12 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 11 Apr 2023 00:54:12 -0700 (PDT) Message-ID: <0b03f91a875fb44182f5bed9e1d404ed6d138066.camel@cybertec.at> Subject: Remove obsolete mention of backslashes as escapes From: Laurenz Albe To: pgsql-docs@lists.postgresql.org Date: Tue, 11 Apr 2023 09:54:11 +0200 Content-Type: multipart/mixed; boundary="=-gdhhO0vUY6ti+1G9cwmo" User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-gdhhO0vUY6ti+1G9cwmo Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 conv= enient, it can be difficult to understand when the desired string contains many s= ingle quotes or backslashes, since each of those must be doubled." But this has been obsolete ever since version 9.1, when "standard_conformin= g_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 --=-gdhhO0vUY6ti+1G9cwmo Content-Disposition: attachment; filename="0001-Remove-obsolete-mention-of-backslashes-as-escapes.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="0001-Remove-obsolete-mention-of-backslashes-as-escapes.patch"; charset="UTF-8" RnJvbSAyODJkMmRhZTI3NTI0YWVmMzdjZGFmZTAyZTQ4MzM4OTRiZjU4OTJjIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogVHVlLCAxMSBBcHIgMjAyMyAwOTo0ODoyMCArMDIwMApTdWJqZWN0OiBbUEFUQ0hd IFJlbW92ZSBvYnNvbGV0ZSBtZW50aW9uIG9mIGJhY2tzbGFzaGVzIGFzIGVzY2FwZXMKClNpbmNl IHZlcnNpb24gOS4xLCBzdGFuZGFyZF9jb25mb3JtaW5nX3N0cmluZ3MgZGVmYXVsdHMgdG8gIm9u Ii4KU28gdGhlIHJlbWFyayB0aGF0IGJhY2tzbGFzaGVzIG11c3QgYmUgZG91YmxlZCBoYXMgYmVl biBvYnNvbGV0ZQpmb3IgYSBsb25nIHRpbWUgYW5kIHNob3VsZCBiZSByZW1vdmVkLiAgSXQgaXMg bW9yZSBjb25mdXNpbmcgdGhhbgpoZWxwZnVsIGJ5IG5vdy4KLS0tCiBkb2Mvc3JjL3NnbWwvc3lu dGF4LnNnbWwgfCAyICstCiAxIGZpbGUgY2hhbmdlZCwgMSBpbnNlcnRpb24oKyksIDEgZGVsZXRp b24oLSkKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvc3ludGF4LnNnbWwgYi9kb2Mvc3JjL3Nn bWwvc3ludGF4LnNnbWwKaW5kZXggNTY2OGFiMDE0My4uM2JhODQ0MDU3ZiAxMDA2NDQKLS0tIGEv ZG9jL3NyYy9zZ21sL3N5bnRheC5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9zeW50YXguc2dtbApA QCAtNTU1LDcgKzU1NSw3IEBAIFUmYW1wOydkITAwNjF0ISswMDAwNjEnIFVFU0NBUEUgJyEnCiAg ICAgPHBhcmE+CiAgICAgIFdoaWxlIHRoZSBzdGFuZGFyZCBzeW50YXggZm9yIHNwZWNpZnlpbmcg c3RyaW5nIGNvbnN0YW50cyBpcyB1c3VhbGx5CiAgICAgIGNvbnZlbmllbnQsIGl0IGNhbiBiZSBk aWZmaWN1bHQgdG8gdW5kZXJzdGFuZCB3aGVuIHRoZSBkZXNpcmVkIHN0cmluZwotICAgICBjb250 YWlucyBtYW55IHNpbmdsZSBxdW90ZXMgb3IgYmFja3NsYXNoZXMsIHNpbmNlIGVhY2ggb2YgdGhv c2UgbXVzdAorICAgICBjb250YWlucyBtYW55IHNpbmdsZSBxdW90ZXMsIHNpbmNlIGVhY2ggb2Yg dGhvc2UgbXVzdAogICAgICBiZSBkb3VibGVkLiBUbyBhbGxvdyBtb3JlIHJlYWRhYmxlIHF1ZXJp ZXMgaW4gc3VjaCBzaXR1YXRpb25zLAogICAgICA8cHJvZHVjdG5hbWU+UG9zdGdyZVNRTDwvcHJv ZHVjdG5hbWU+IHByb3ZpZGVzIGFub3RoZXIgd2F5LCBjYWxsZWQKICAgICAgPHF1b3RlPmRvbGxh ciBxdW90aW5nPC9xdW90ZT4sIHRvIHdyaXRlIHN0cmluZyBjb25zdGFudHMuCi0tIAoyLjM5LjIK Cg== --=-gdhhO0vUY6ti+1G9cwmo--