BUG #3438: Problem selecting backslash from a byte array
От | radoslav hodnicak |
---|---|
Тема | BUG #3438: Problem selecting backslash from a byte array |
Дата | |
Msg-id | 200707111557.l6BFvpJD051057@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3438: Problem selecting backslash from a byte array
Re: BUG #3438: Problem selecting backslash from a byte array |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 3438 Logged by: radoslav hodnicak Email address: rh@4096.sk PostgreSQL version: 8.2.4 Operating system: Windows XP SP2 Description: Problem selecting backslash from a byte array Details: I create a table with a byte array column and insert a row with the byte 92 into it (which is backslash). Then I want to select the row. Steps to reproduce: create table backslashtest (test bytea null); insert into backslashtest values (E'\\134'::bytea); select * from backslashtest where test like E'\\134'::bytea; Result: select returns no rows Expected result: select should return the row I've inserted Other remarks: select * from backslashtest where test like E'\\134\\134'::bytea; does what I expected from the original select, but that's wrong because I don't want two backslashes, only one
В списке pgsql-bugs по дате отправления: