BUG #2231: Incorrect Order By - Mailing list pgsql-bugs

From Garoso, Fernando
Subject BUG #2231: Incorrect Order By
Date
Msg-id 20060201162323.8525BF0B00@svr2.postgresql.org
Whole thread Raw
Responses Re: BUG #2231: Incorrect Order By
List pgsql-bugs
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 ;)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug in query planer ?
Next
From: michael
Date:
Subject: Re: BUG #2228: escaped single quotes choke spi_exec_query in