On Friday 24 October 2008, "Gauthier, Dave" <[EMAIL PROTECTED]> wrote: > I read in the docs (section 9.7.1) that the backslash... \ ... is the > default escape char to use in "like" expressions. Yet when I try it, it > doesn't seem to work the ay I expect. Here's an example... > > select name from templates where name like '%\_cont\_%'; >
Use double \\ for underscores. I don't know why it's necessary, but it works here. -- Alan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
