"radoslav hodnicak" <[EMAIL PROTECTED]> writes:
> create table backslashtest (test bytea null);
> insert into backslashtest values (E'\\134'::bytea);
> select * from backslashtest where test like E'\\134'::bytea;
Backslash is a special character to LIKE. Perhaps you would prefer
to specify another escape character, or none at all:
select * from backslashtest where test like E'\\134'::bytea escape '';
If you don't want any special pattern characters, why are you using
LIKE rather than plain = ?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
