Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 718DD47591A
	for <pgsql-sql@postgresql.org>; Tue, 14 May 2002 08:02:14 -0400 (EDT)
Received: from harbinger.sirma.bg (harbinger.sirma.bg [62.213.161.140])
	by postgresql.org (Postfix) with ESMTP id 59E5F4758F8
	for <pgsql-sql@postgresql.org>; Tue, 14 May 2002 08:02:12 -0400 (EDT)
Received: (from root@localhost)
	by harbinger.sirma.bg (8.9.3/8.9.3) id PAA22177;
	Tue, 14 May 2002 15:02:07 +0300
Received: from redhat.sirma.bg (mail.sirma.bg [62.213.161.133])
	by harbinger.sirma.bg (8.9.3/8.9.3) with ESMTP id PAA22172;
	Tue, 14 May 2002 15:02:06 +0300
Received: from pillango (pillango.sirma.int [192.168.128.42])
	by redhat.sirma.bg (8.9.3/8.9.3) with SMTP id PAA23686;
	Tue, 14 May 2002 15:02:08 +0300
Message-ID: <006301c1fb3f$249aa2f0$9ba1d53e@sirma.bg>
From: "Marin Dimitrov" <marin.dimitrov@sirma.bg>
To: "Mathieu Arnold" <mat@mat.cc>, <pgsql-sql@postgresql.org>
References: <1713675304.1021384181@andromede.reaumur.absolight.net>
Subject: Re: order by <something wierd>
Date: Tue, 14 May 2002 15:01:55 +0300
Organization: Sirma AI
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
X-Virus-Scanned: 
X-Archive-Number: 200205/130
X-Sequence-Number: 7766


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