Bill Moran wrote:
> You need to spend some quality time with the documentation. Seriously,
> the issue _is_ confusing, but the docs explain it all, if you take the
> time to read all of it.
>
> To directly answer your question, \s is not a recognized escape sequence,
> so PG passes it unchanged.
>
> However, if you were trying to pass a \f, you would need to escape the \,
> like this '\\f', otherwise the \f would be converted to a form feed before
> LIKE ever saw it.
>
and, naturally, this gets even more complicated and confusing when the
string is a literal in a C/Perl/etc program that has its OWN escaping
going on.