Escaping special characters - Mailing list pgsql-general

From Neanderthelle Jones
Subject Escaping special characters
Date
Msg-id Pine.LNX.4.64.0903172219120.2728@calypso.view.net.au
Whole thread Raw
Responses Re: Escaping special characters  (Thom Brown <thombrown@gmail.com>)
Re: Escaping special characters  (Richard Huxton <dev@archonet.com>)
Re: Escaping special characters  (Sam Mason <sam@samason.me.uk>)
Re: Escaping special characters  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
About the string "Smith \& Jones".

According to the documentation,

INSERT INTO thing (name) VALUES ('Smith E'\\'& Jones');

must work.  But it doesn't.  So, double the enclosed quotes:

INSERT INTO thing (name) VALUES ('Smith E''\\''& Jones');

Doesn't.

It works fine, but with a warning, as

INSERT INTO thing (name) VALUES ('Smith \\& Jones');

But it mightn't if I upgrade from 8.2.3.  Deprecated.  Can't risk it.
So 40,000 years from now I'll be on 8.2.3.

Granted, I'm not very bright.  Would appreciate your help.

--Elle

pgsql-general by date:

Previous
From: Howard Cole
Date:
Subject: Re: Postgres 8.2.x support on Windows 2008
Next
From: Richard Huxton
Date:
Subject: Re: Records Number