BUG #5535: Backslash in condition for LIKE statement is not seen

The following bug has been logged online:

Bug reference: 5535
Logged by: Jeff Benjamin
Email address: jeff(at)ivertex(dot)com
PostgreSQL version: 8.3.8
Operating system: MacOSX, Linux
Description: Backslash in condition for LIKE statement is not seen
Details:

Seems one cannot use a backslash character in a LIKE condition.

backslashprob=# create table test ( pattern varchar(50) );
CREATE TABLE
backslashprob=# insert into test (pattern) values ('\\w{12}');
INSERT 0 1
backslashprob=# select * from test;
pattern
---------
\w{12}
(1 row)

backslashprob=# select * from test where pattern like '\\w%';
pattern
---------
(0 rows)

backslashprob=# select * from test where pattern like E'\\w%';
pattern
---------
(0 rows)

backslashprob=# select * from test where pattern like '%w%';
pattern
---------
\w{12}
(1 row)