Re: Show CAS, USD first; the left ordered by currency name

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