Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B8008632179 for ; Thu, 30 Jul 2009 16:51:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91715-05 for ; Thu, 30 Jul 2009 19:51:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from perseverance.services.encs.concordia.ca (perseverance-96.encs.concordia.ca [132.205.96.94]) by mail.postgresql.org (Postfix) with ESMTP id 1430D6351B6 for ; Thu, 30 Jul 2009 16:51:40 -0300 (ADT) Received: from cacao.encs.concordia.ca (emilu@cacao.encs.concordia.ca [132.205.47.225]) by perseverance.services.encs.concordia.ca (envelope-from emilu@encs.concordia.ca) (8.13.7/8.13.7) with ESMTP id n6UJpdNe025633 for ; Thu, 30 Jul 2009 15:51:39 -0400 Message-ID: <4A71F9CB.9050805@encs.concordia.ca> Date: Thu, 30 Jul 2009 15:51:39 -0400 From: Emi Lu Reply-To: emilu@encs.concordia.ca User-Agent: Thunderbird 2.0.0.21 (X11/20090302) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Show CAS, USD first; the left ordered by currency name Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.58 on perseverance.encs.concordia.ca at 2009/07/30 15:51:39 EDT X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=-10 required=5 tests=none X-Spam-Level: X-Archive-Number: 200907/156 X-Sequence-Number: 32897 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