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

<div dir="ltr">...order by currency not in('USD', 'AND', 'CAD');<br /><br />this condition will be avaluated as FALSE
forUSD, AND and CAD, and as TRUE for all other currencies. When the records are sorted the "false" are placed on the
topbecause false<true;.<br /><br /><div class="gmail_quote">On Thu, Jul 30, 2009 at 10:51 PM, Emi Lu <span
dir="ltr"><<ahref="mailto:emilu@encs.concordia.ca">emilu@encs.concordia.ca</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Goodmorning,<br /><br /> I have a currency table (code, description).<br /><br /> Example values:<br />  ADF | Andorran
Franc<br/>  ... ...<br />  ANG | NL Antillian Guilder<br />  AON | Angolan New Kwanza<br />  AUD | Australian Dollar<br
/> AWG | Aruban Florin<br />  BBD | Barbados Dollar<br />  USD | US Dollar<br />  CAD | Canadian Dollar<br /><br /> Is
therea way I can query to display USD AND CAD first, while other rows are ordered by Code.<br /><br /> For example,<br
/><br/> CAS | Canadian Dollar<br /> USD | US Dollar<br /> ADF | Andorran Franc<br /> ...<br /><br /><br /> Thanks a
lot!<br/> --<br /> Lu Ying<br /><font color="#888888"><br /><br /><br /> -- <br /> Sent via pgsql-sql mailing list (<a
href="mailto:pgsql-sql@postgresql.org"target="_blank">pgsql-sql@postgresql.org</a>)<br /> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br /></div>