BUG #2231: Incorrect Order By

From: "Garoso, Fernando" <fgaroso(at)ig(dot)com(dot)br>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2231: Incorrect Order By
Date: 2006-02-01 16:23:23
Message-ID: 20060201162323.8525BF0B00@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 2231
Logged by: Garoso, Fernando
Email address: fgaroso(at)ig(dot)com(dot)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 ;)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Clifford Wolf 2006-02-01 16:44:10 Re: Bug in query planer ?
Previous Message michael 2006-02-01 15:43:13 Re: BUG #2228: escaped single quotes choke spi_exec_query in