From: Marin Dimitrov <marin.dimitrov@sirma.bg>
To: Mathieu Arnold <mat@mat.cc>
To: pgsql-sql@postgresql.org
Subject: Re: order by <something wierd>
Date: Tue, 14 May 2002 15:01:55 +0300
Message-ID: <006301c1fb3f$249aa2f0$9ba1d53e@sirma.bg> (raw)
References: <1713675304.1021384181@andromede.reaumur.absolight.net>
----- 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. "
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: marin.dimitrov@sirma.bg, mat@mat.cc
Subject: Re: order by <something wierd>
In-Reply-To: <006301c1fb3f$249aa2f0$9ba1d53e@sirma.bg>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox