"Rainer" <rainer@hamburg.ccc.de> writes:
> 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