From: Emi Lu <emilu@encs.concordia.ca>
To: sergey kapustin <kapustin.sergey@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Show CAS, USD first; the left ordered by currency name
Date: Fri, 31 Jul 2009 10:05:49 -0400
Message-ID: <4A72FA3D.7090505@encs.concordia.ca> (raw)
In-Reply-To: <cf82f1380907301306yb51e3ecy387d40e915cd1c2c@mail.gmail.com>
References: <4A71F9CB.9050805@encs.concordia.ca>
<cf82f1380907301306yb51e3ecy387d40e915cd1c2c@mail.gmail.com>
"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@encs.concordia.ca
> <mailto: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
> <mailto:pgsql-sql@postgresql.org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: emilu@encs.concordia.ca, kapustin.sergey@gmail.com
Subject: Re: Show CAS, USD first; the left ordered by currency name
In-Reply-To: <4A72FA3D.7090505@encs.concordia.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox