Re: BUG #4398: Backslashes get escaped despite of backslash_quote=off

Поиск
Список
Период
Сортировка
От Rainer Glueck
Тема Re: BUG #4398: Backslashes get escaped despite of backslash_quote=off
Дата
Msg-id 48C1087E.10389.3CFE48D@rainer.glueck.netminds.de
обсуждение исходный текст
Ответ на Re: BUG #4398: Backslashes get escaped despite of backslash_quote=off  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Tom,

On 4 Sep 2008 at 12:53, Tom Lane wrote:
>
> "Rainer Glueck" <rainer.glueck@netminds.de> writes:
> > How can backslashes be stopped from escaping themselves in like-statements
>
> Use ESCAPE ''.  There isn't any other way provided.
> ...
> if you have no escape character then you have no way to quote % and _

Yes, that's true indeed.
And since I learned that the escape clause is recommended to cope
with that matter not only by PostgreSQL, but also by Transact-SQL,
I'm going to adapt my database connector this way, withdraw this topic
and thank you for pushing me a little bit more to enlightenment. :)

Regards,
Rainer




-----BEGIN PGP SIGNATURE-----
Version: idw's PGP-Frontend 5.1.0.0 / 4-2006 + PGP 6.5.8
Comment: KEY: 0x231D96D8 - FP: 9E01C5D7 7041D0C4 804F4705 76216606 231D96D8

iQA/AwUBSMDeV3YhZgYjHZbYEQKv3gCgx6UWMbVLsym6hb8/DG91JMNX3OAAoK9M
NrpA0F3AGjPeqacOks2AVtJe
=8SXN
-----END PGP SIGNATURE-----

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Joachim Unger"
Дата:
Сообщение: BUG #4402: Column expansion: date comes wthout a cast
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #4374: pg_restore does not restore public schema comment