The following bug has been logged online:
Bug reference: 1590
Logged by: Michaela
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: SuSE Linux 9.1
Description: Comparison Operation with Strings
Details:
Hello!
conditions:
-----------
Our database is defined with SQL_ASCII. We also tested Latin1.
CREATE TABLE test(feld varchar(100))
INSERT INTO test VALUES ('ABC');
INSERT INTO test VALUES ('?');
INSERT INTO test VALUES ('100');
INSERT INTO test VALUES ('B');
INSERT INTO test VALUES ('? ABC');
INSERT INTO test VALUES ('Z');
We want to use e.g. the following conditions:
1.example
---------
select * from test where field>='?' and field<'A'
result:
?
100
But it doesn`t find the '? ABC'. And '100' is wrong.
This command should give me this output:
?
? ABC
2.example
---------
select * from test where feld>='?' and feld<'@'
result:
?
It doesn`t find the '? ABC'.
This command should give me this output:
?
? ABC
3.example
---------
select * from test where feld>='A' and feld<'C'
result:
ABC
B
? ABC
the correct result would be:
ABC
B
We tested it with PostgreSQL version 7.2.1. There it works.
Kind Regards
Michaela
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
