DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=cDN5PXcuFzNWPf/zMTDAM7qVb/tnZFcRLKAqQG1eMbkzK3UCqC4Bqt+ij3G1jjNowcvz5BV3qKKYlTy0VY3x/b35mxtWt/77DsI+a3yOKi1kgWbLJYxic9Ns92xzEF+pcu0Vp++W1kc6Wq3hDkBLNUi10KQWRrynVEB3qraL1QQ=
Message-ID: <a55915760703140914q5883f01fud0572153e575285d@mail.gmail.com>
Date: Wed, 14 Mar 2007 11:14:49 -0500
From: "=?ISO-8859-1?Q?Rodrigo_De_Le=F3n?=" <rdeleonp@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: ordering by multiple columns
Cc: "=?ISO-8859-1?Q?Pablo_Barr=F3n?=" <amentoraz@gmail.com>
In-Reply-To: <d4d13b4c0703140850i4957116bw8a25255131a56346@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <d4d13b4c0703140850i4957116bw8a25255131a56346@mail.gmail.com>

On 3/14/07, Pablo Barr=F3n <amentoraz@gmail.com> wrote:
>  Hi!
>
>  I'm trying to order a list in which the first parameter to order is a
> specific field, and the second should vary depending on a specific
> condition. More explicit, I would like to do something like:
>
>  - ORDER BY a.column1, [b.column2 if c.value !=3D 19 || c.column2 if
> c.value=3D=3D19]
>
>  That is to say, use a column if a value on each row isn't 19, OR use a
> different column if it isn't. How could I solve this? I've got to have a
> global order over my query, so I cannot separate it into two queries, etc
> :-?
>
>  Thank you!

SELECT   (...)
ORDER BY a.column1, CASE
           WHEN c.VALUE <> 19
             THEN b.column2
           ELSE c.column2
         END;