"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 <em...@encs.concordia.ca
<mailto:em...@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
<mailto:pgsql-sql@postgresql.org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
