> Description: Backslashes get escaped despite of backslash_quote=off
Aren't you looking for standard_conforming_strings? backslash_quote is
something else entirely, and doesn't actually do anything at all when
backslash escaping is disabled.
> Two questions:
> 1. What I actually want: Shouldn't the second statement work by
> documentation without the escape flag?
No. standard_conforming_strings has nothing to do with the behavior of
LIKE (nor does backslash_quote). They just control the initial parsing
of SQL string literals.
> 2. What I do not understand: Why does the fourth statement return a result
> as backslash_quote is off?
It looks like a perfectly good match to me.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
No comments:
Post a Comment