----- 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. "