Re: non-static LIKE patterns

patrick keshishian <pkeshish@gmail.com> writes:
> I need to match entries in second table to the first, so I use the
> following in my WHERE clause:
>     ... WHERE second.path LIKE first.path||'%'
> This seemed to work at first, but it fails if the paths use
> back-slashes (like Windows paths).

By default, back-slash is a special character in LIKE patterns.
You can change that with the ESCAPE option.  See
http://www.postgresql.org/docs/devel/static/functions-matching.html#FUNCTIONS-LIKE

            regards, tom lane