The following bug has been logged online:
Bug reference: 2231
Logged by: Garoso, Fernando
Email address: fgaroso@ig.com.br
PostgreSQL version: 8.x
Operating system: GNU Linux Debian
Description: Incorrect Order By
Details:
create table tmp ( name char(30) );
create index tmp_idx on tmp (name);
insert into tmp values ( 'SUEKO' );
insert into tmp values ( 'SUE E' );
insert into tmp values ( 'SUE T' );
select * from tmp order by name;
### Result ###
teste=# select * from tmp order by name desc;
name
--------------------------------
SUE T
SUEKO
SUE E
(3 registros)
### Note ###
Version for windows => OK Order ;)