Re: LIKE with pattern containing backslash

Jack Orenstein wrote:

> In this code, The string passed to JDBC is %\% (percent, one
> backslash, percent), and no rows are returned.
> It appears as if the one backslash is being treated as an
> escape for the %.

That's right. So \% as a pattern matches a percent, and \\ as a pattern
matches a backslash. This has nothing to do with literals and all to do
with the special role of backslash in LIKE.

From your program:

> // Find rows with at least one backslash
> String oneBackslash = new String(new char[]{'%', '\\',
'%'});

Actually, this will find rows ending with a percent.

> // Find rows with at least two backslashes
> String twoBackslashes = new String(new char[]{'%', '\\',
'\\', '%'});

Actually, this will find rows having at least one backslash.

The point is the lack of an ESCAPE clause to LIKE. Just add it to
disable the special role of backslash and the patterns will match as
you expect.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage:
http://www.manitou-mail.org