String operators <= and >= - Mailing list pgsql-ports

From Patrick Vachon
Subject String operators <= and >=
Date
Msg-id BAY8-F72h331DPrZjuy0001050e@hotmail.com
Whole thread Raw
Responses Re: String operators <= and >=
List pgsql-ports
Hi

We have a strange problem when searching for a string using <= and >=
operators on Solaris.
It did work with 7.3, but not with 7.3.3, 7.3.4 and 7.4.1.
The database have been initialized with locale en_US.ISO8859-1

Have a simple table testtbl:
create table testtbl ( id int, name varchar(20));
Insert this record:
insert into testtbl values(10, 'PEREZ');
Now do that search:
select * from testtbl where name >= 'PERE' and name <= 'PERE\377';

It should return the record of the table, but it will not return it with
version 7.3.3 and later.
We still found that workaround works:
select * from testtbl where name >= 'PERE' and name <= 'PEREzz';

Which is pretty strange...
Any comments about that? Is it a bug?

Thanks,
Patrick

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.

http://join.msn.com/?page=dept/features&pgmarket=en-ca&RU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca


pgsql-ports by date:

Previous
From: "Merlin Moncure"
Date:
Subject: FW: [pgsql-hackers-win32] more info from the interix port
Next
From: Tom Lane
Date:
Subject: Re: String operators <= and >=