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