pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedShow CAS, USD first; the left ordered by currency name
6+ messages / 5 participants
[nested] [flat]
* Show CAS, USD first; the left ordered by currency name
@ 2009-07-30 19:51 Emi Lu <emilu@encs.concordia.ca>
0 siblings, 3 replies; 6+ messages in thread
From: Emi Lu @ 2009-07-30 19:51 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Show CAS, USD first; the left ordered by currency name
@ 2009-07-30 20:05 Andreas Kretschmer <akretschmer@spamfence.net>
parent: Emi Lu <emilu@encs.concordia.ca>
2 siblings, 0 replies; 6+ messages in thread
From: Andreas Kretschmer @ 2009-07-30 20:05 UTC (permalink / raw)
To: pgsql-sql
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
> ...
>
Sure:
test=*# select * from currency order by case when code='USD' then 0 when
code = 'CAD' then 1 end, code;
code | description
------+----------------------
USD | US Dollar
CAD | Canadian Dollar
ADF | Andorran Franc
ANG | NL Antillian Guilder
AON | Angolan New Kwanza
AUD | Australian Dollar
AWG | Aruban Florin
BBD | Barbados Dollar
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Show CAS, USD first; the left ordered by currency name
@ 2009-07-30 20:06 sergey kapustin <kapustin.sergey@gmail.com>
parent: Emi Lu <emilu@encs.concordia.ca>
2 siblings, 1 reply; 6+ messages in thread
From: sergey kapustin @ 2009-07-30 20:06 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
...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
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Show CAS, USD first; the left ordered by currency name
@ 2009-07-31 11:37 Harald Fuchs <hari.fuchs@gmail.com>
parent: Emi Lu <emilu@encs.concordia.ca>
2 siblings, 1 reply; 6+ messages in thread
From: Harald Fuchs @ 2009-07-31 11:37 UTC (permalink / raw)
To: pgsql-sql
In article <4A71F9CB.9050805@encs.concordia.ca>,
Emi Lu <emilu@encs.concordia.ca> writes:
> 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
> ...
Probably the shortest solution is
SELECT code, description
FROM currency
ORDER BY code != 'CAD', code != 'USD', code;
BTW: your data are obsolete. Andorra has the Euro.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Show CAS, USD first; the left ordered by currency name
@ 2009-07-31 13:27 bricklen <bricklen@gmail.com>
parent: Harald Fuchs <hari.fuchs@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: bricklen @ 2009-07-31 13:27 UTC (permalink / raw)
To: emilu@encs.concordia.ca; +Cc: pgsql-sql
Alternatively,
...
ORDER BY (case when code in ('USD','CAD') then 0 else 1 end),code
On Fri, Jul 31, 2009 at 4:37 AM, Harald Fuchs<hari.fuchs@gmail.com> wrote:
> In article <4A71F9CB.9050805@encs.concordia.ca>,
> Emi Lu <emilu@encs.concordia.ca> writes:
>
>> 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
>> ...
>
> Probably the shortest solution is
>
> SELECT code, description
> FROM currency
> ORDER BY code != 'CAD', code != 'USD', code;
>
> BTW: your data are obsolete. Andorra has the Euro.
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Show CAS, USD first; the left ordered by currency name
@ 2009-07-31 14:05 Emi Lu <emilu@encs.concordia.ca>
parent: sergey kapustin <kapustin.sergey@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Emi Lu @ 2009-07-31 14:05 UTC (permalink / raw)
To: sergey kapustin <kapustin.sergey@gmail.com>; +Cc: 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@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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2009-07-31 14:05 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-07-30 19:51 Show CAS, USD first; the left ordered by currency name Emi Lu <emilu@encs.concordia.ca>
2009-07-30 20:05 ` Andreas Kretschmer <akretschmer@spamfence.net>
2009-07-30 20:06 ` sergey kapustin <kapustin.sergey@gmail.com>
2009-07-31 14:05 ` Emi Lu <emilu@encs.concordia.ca>
2009-07-31 11:37 ` Harald Fuchs <hari.fuchs@gmail.com>
2009-07-31 13:27 ` bricklen <bricklen@gmail.com>
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