"Jeff Benjamin" <jeff(at)ivertex(dot)com> wrote:
> Seems one cannot use a backslash character in a LIKE condition.
By default that has special meaning as an escape character.
Try this:
select * from test where pattern like E'\\w%' escape '#';
or this:
select * from test where pattern like E'\\\\w%';
-Kevin