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 по дате отправления: