| 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: | Whole Thread | Raw Message | 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 ;)
| 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 |