MIME-Version: 1.0
References: <CANzqJaD0=V+Dh+mLLfLj4ECLHriAH122LiYaqKyAnWCAKCfa6A@mail.gmail.com>
 <CAKFQuwbdAm7=RziKxF+jQki0KXb-quan5fA3sfq8JKoDR3Jumw@mail.gmail.com>
 <CANzqJaCL_p2LmCAUPGUYxOJPN-iOs-JWbpU4ssH+rSw27DmvhA@mail.gmail.com>
 <CAKFQuwZhOgbn+wbDTRXyqON2AEJM-R_Na2yHjLD0r9V4a+Fx=Q@mail.gmail.com>
 <CANzqJaDTY0AEB2zxumCbDtZu_pVxcjWpf5FdSeGwShLM3SfVzg@mail.gmail.com>
 <730017.1718032111@sss.pgh.pa.us> <CANzqJaDqZtWfk=s1_886m7TzTMek87Qcefpns4WRBvjm-9f-_w@mail.gmail.com>
In-Reply-To: <CANzqJaDqZtWfk=s1_886m7TzTMek87Qcefpns4WRBvjm-9f-_w@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Mon, 10 Jun 2024 08:42:00 -0700
Message-ID: <CAKFQuwY0UxAeuCQTYtpyxZ83O8D=g5nAT8_7pSRtEG-FaHsUpg@mail.gmail.com>
Subject: Re: Escaping single quotes with backslash seems not to work
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bec317061a8aff0c"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwY0UxAeuCQTYtpyxZ83O8D%3Dg5nAT8_7pSRtEG-FaHsUpg%40mail.gmail.com>
Precedence: bulk

--000000000000bec317061a8aff0c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Jun 10, 2024 at 8:19=E2=80=AFAM Ron Johnson <ronljohnsonjr@gmail.co=
m> wrote:

>
> "set standard_encoding_strings =3D on" is at the top, and there's no othe=
r
> reference to it.
>
>
Well, if they are not using E-strings for escapes then you have the answer
why v14 is broken.  Does it really matter why v9.6 apparently worked even
though it should not have if that setting was also set to on?

David J.

--000000000000bec317061a8aff0c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Mon, Jun 10, 2024 at 8:19=E2=80=AFAM Ron Johnson &lt;<a=
 href=3D"mailto:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wr=
ote:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><d=
iv class=3D"gmail_quote"><div>&quot;set standard_encoding_strings =3D on&qu=
ot; is at the top, and there&#39;s no other reference to it.</div><div><br>=
</div></div></div></blockquote><div><br></div><div class=3D"gmail_default" =
style=3D"font-family:arial,helvetica,sans-serif">Well, if they are not usin=
g E-strings for escapes then you have the answer why v14 is broken.=C2=A0 D=
oes it really matter why v9.6 apparently worked even though it should not h=
ave if that setting was also set to on?</div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif"><br></div><div class=3D"gma=
il_default" style=3D"font-family:arial,helvetica,sans-serif">David J.</div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f"><br></div></div></div>

--000000000000bec317061a8aff0c--