Re: order by

----- Original Message ----- 
From: "Mathieu Arnold" 

> then 1 and then 3. so that the result should be :
> 
> 1 | one   | 1
> 3 | three | 2
> 5 | five  | 2
> 2 | two   | 3
> 4 | four  | 3
> 
> How could I do that ?
> 

gate09=# select * from a order by 3,1,2;
c1 |  c2   | c3 
----+-------+---- 1 | one   |  1 3 | three |  2 5 | five  |  2 2 | two   |  3 4 | four  |  3


hth,
   Marin

----
"...what you brought from your past, is of no use in your present. When 
you must choose a new path, do not bring old experiences with you. 
Those who strike out afresh, but who attempt to retain a little of the 
old life, end up torn apart by their own memories. "