Message-ID: <4A72FA3D.7090505@encs.concordia.ca>
Date: Fri, 31 Jul 2009 10:05:49 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Thunderbird 2.0.0.21 (X11/20090302)
MIME-Version: 1.0
To: sergey kapustin <kapustin.sergey@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: Show CAS, USD first; the left ordered by currency name
References: <4A71F9CB.9050805@encs.concordia.ca>
	<cf82f1380907301306yb51e3ecy387d40e915cd1c2c@mail.gmail.com>
In-Reply-To: <cf82f1380907301306yb51e3ecy387d40e915cd1c2c@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

"order by code not in ('USD', 'EUR', 'CAD') , code" is exactly what I 
was looking for!

Good to know how "order by not in" works and thank you very much for all 
your inputs!

--
Lu Ying


> ...order by currency not in('USD', 'AND', 'CAD');
> 
> this condition will be avaluated as FALSE for USD, AND and CAD, and as 
> TRUE for all other currencies. When the records are sorted the "false" 
> are placed on the top because false<true;.
> 
> On Thu, Jul 30, 2009 at 10:51 PM, Emi Lu <emilu@encs.concordia.ca 
> <mailto:emilu@encs.concordia.ca>> wrote:
> 
>     Good morning,
> 
>     I have a currency table (code, description).
> 
>     Example values:
>      ADF | Andorran Franc
>      ... ...
>      ANG | NL Antillian Guilder
>      AON | Angolan New Kwanza
>      AUD | Australian Dollar
>      AWG | Aruban Florin
>      BBD | Barbados Dollar
>      USD | US Dollar
>      CAD | Canadian Dollar
> 
>     Is there a way I can query to display USD AND CAD first, while other
>     rows are ordered by Code.
> 
>     For example,
> 
>     CAS | Canadian Dollar
>     USD | US Dollar
>     ADF | Andorran Franc
>     ...
> 
> 
>     Thanks a lot!
>     --
>     Lu Ying
> 
> 
> 
>     -- 
>     Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org
>     <mailto:pgsql-sql@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-sql
> 
>