From: | "Patrick Vachon" <kaleidelf(at)hotmail(dot)com> |
---|---|
To: | pgsql-ports(at)postgresql(dot)org |
Subject: | String operators <= and >= |
Date: | 2004-02-26 19:16:41 |
Message-ID: | BAY8-F72h331DPrZjuy0001050e@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-26 19:33:19 | Re: String operators <= and >= |
Previous Message | Merlin Moncure | 2004-02-18 14:32:01 | FW: [pgsql-hackers-win32] more info from the interix port |