Re: LIKE with pattern containing backslash
От | Daniel Verite |
---|---|
Тема | Re: LIKE with pattern containing backslash |
Дата | |
Msg-id | 2ef31fa3-2b0b-4f99-8982-82e33bbf2cf4@mm обсуждение исходный текст |
Ответ на | Re: LIKE with pattern containing backslash (Jack Orenstein <jack.orenstein@hds.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: