patrick keshishian <pkesh...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
