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

[Emi Lu <emilu(at)encs(dot)concordia(dot)ca>]

"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(at)encs(dot)concordia(dot)ca 
> <mailto:emilu(at)encs(dot)concordia(dot)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(at)postgresql(dot)org
>     <mailto:pgsql-sql(at)postgresql(dot)org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-sql