> ----- 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;
This won't work - it will order by the third param, then first, then
second...
Chris