Request a Demo
Home   >   mailing lists

Re: Show CAS, USD first; the left ordered by currency name - Mailing list pgsql-sql

From sergey kapustin
Subject Re: Show CAS, USD first; the left ordered by currency name
Date
Msg-id cf82f1380907301306yb51e3ecy387d40e915cd1c2c@mail.gmail.com
Whole thread Raw
In response to Show CAS, USD first; the left ordered by currency name  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: Show CAS, USD first; the left ordered by currency name
List pgsql-sql
Tree view
...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> 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)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

pgsql-sql by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Show CAS, USD first; the left ordered by currency name
Next
From: nha
Date:
Subject: Re: SELECT max(time) group by problem