From: | "radoslav hodnicak" <rh(at)4096(dot)sk> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #3438: Problem selecting backslash from a byte array |
Date: | 2007-07-11 15:57:51 |
Message-ID: | 200707111557.l6BFvpJD051057@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3438
Logged by: radoslav hodnicak
Email address: rh(at)4096(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2007-07-11 16:28:47 | Re: BUG #3438: Problem selecting backslash from a byte array |
Previous Message | Shuo Liu | 2007-07-10 22:32:50 | exit code -1073741819 |