Emi Lu <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
> ...
>
Sure:
test=*# select * from currency order by case when code='USD' then 0 when
code = 'CAD' then 1 end, code;code | description
------+----------------------USD | US DollarCAD | Canadian DollarADF | Andorran FrancANG | NL Antillian GuilderAON
|Angolan New KwanzaAUD | Australian DollarAWG | Aruban FlorinBBD | 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°