From: Prasanth Kumar <kumar1@home.com>
To: pgsql-sql@postgresql.org
Subject: Re: Order By Question
Date: Tue, 23 Jan 2001 23:51:50 -0800
Message-ID: <003b01c085da$82aaa4c0$afc8b018@c654771a> (raw)
References: <3A6CD7E4.8BE6DDC3@pacbell.net>
<snip>
> This seems like the answer must be pretty easy, but I can't think of it:
>
> In the following statement:
>
> select field1 from my_table where field2 in (3, 1, 2);
>
> How can I modify this statement so that the record are returned in the
> order of first those records having field2 = 3, then field2 = 1, then
> field2 = 2.
> As it stands, I am getting them returned in the order of the value of
> field1.
>
<snip>
One way is to have a priority table where each value is mapped to its
associated priority and then you do a join against this table and order by
the priority value instead.
So you might have a table like follows:
priority value
1 3
2 1
3 2
--
Prasanth Kumar
kumar1@home.com
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: kumar1@home.com
Subject: Re: Order By Question
In-Reply-To: <003b01c085da$82aaa4c0$afc8b018@c654771a>
* 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