Re: BUG #2231: Incorrect Order By

On Wed, 1 Feb 2006, Garoso, Fernando wrote:

>
> 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)

What locale are you using?  The above looks correct to my eye for en_US
locale on most linux systems which use dictionary sorting.