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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
