BUG #3438: Problem selecting backslash from a byte array

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

Responses

Browse pgsql-bugs by date

  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