[BUGS] BUG #2231: Incorrect Order By

[Garoso, Fernando]

The following bug has been logged online:

Bug reference:      2231
Logged by:          Garoso, Fernando
Email address:      [EMAIL PROTECTED]
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 ;)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend