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

[Andreas Kretschmer <akretschmer(at)spamfence(dot)net>]

Emi Lu <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
> ...
>

Sure:

test=*# select * from currency order by case when code='USD' then 0 when
code = 'CAD' then 1 end, code;
 code |     description
------+----------------------
 USD  | US Dollar
 CAD  | Canadian Dollar
 ADF  | Andorran Franc
 ANG  | NL Antillian Guilder
 AON  | Angolan New Kwanza
 AUD  | Australian Dollar
 AWG  | Aruban Florin
 BBD  | Barbados Dollar




Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°