Re: Escaping special characters
| От | Thom Brown |
|---|---|
| Тема | Re: Escaping special characters |
| Дата | |
| Msg-id | bddc86150903170531y24430952n1472a0452b4cf4be@mail.gmail.com обсуждение исходный текст |
| Ответ на | Escaping special characters (Neanderthelle Jones <elle@view.net.au>) |
| Ответы |
Re: Escaping special characters
|
| Список | pgsql-general |
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.
I could be wrong, but shouldn't it be:
INSERT INTO thing (name) VALUES ('Smith E'\\& Jones');
I'm not sure why you're including an extra single or double-quote in the string.
Regards
Thom
В списке pgsql-general по дате отправления: