From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
---|---|
To: | sergey kapustin <kapustin(dot)sergey(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Show CAS, USD first; the left ordered by currency name |
Date: | 2009-07-31 14:05:49 |
Message-ID: | 4A72FA3D.7090505@encs.concordia.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
"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 <emilu(at)encs(dot)concordia(dot)ca
> <mailto: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
> ...
>
>
> Thanks a lot!
> --
> Lu Ying
>
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org
> <mailto:pgsql-sql(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jasmin Dizdarevic | 2009-07-31 15:24:26 | on error resume next |
Previous Message | bricklen | 2009-07-31 13:27:50 | Re: Show CAS, USD first; the left ordered by currency name |