Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Pavel StehuleDate: 2007-07-11 16:28:47
Subject: Re: BUG #3438: Problem selecting backslash from a byte array
Previous:From: Shuo LiuDate: 2007-07-10 22:32:50
Subject: exit code -1073741819

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group