"Tony" <tonya(at)ananzi(dot)co(dot)za> writes:
> When running a query such as:
> select folder from public.folders
> where lower(folder) like '%c:\\1%'
> no rows are returned
This is not a bug --- you've forgotten that backslash is an escape
character in LIKE patterns. You can either double it again:
like '%c:\\\\1%'
or select a different escape character, or maybe better not have any
escape character at all:
like '%c:\\1%' escape ''
See
http://www.postgresql.org/docs/8.1/static/functions-matching.html#FUNCTIONS-LIKE
regards, tom lane