Re: order by - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: order by
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEJMCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: order by  ("Marin Dimitrov" <marin.dimitrov@sirma.bg>)
List pgsql-sql
> ----- 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



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: can't cast varchar as integer?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: date_part, how to use