From: | "Daniel T(dot) Staal" <DStaal(at)usa(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Order by sub-select |
Date: | 2008-01-09 17:12:21 |
Message-ID: | 61849.63.172.115.138.1199898741.squirrel@MageHandbook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
In the following query:
SELECT name, contact, phone, email FROM eforward.address
WHERE gsb IN ( SELECT gsb FROM eforward.ibox
WHERE ibx IN ( SELECT DISTINCT ibx FROM eforward.partner
WHERE pibx = 'MTCBIN'));
How would I sort the result by eforward.partner.ibx? I tried an 'ORDER
BY' clause in the sub-select, but that doesn't appear to work. (If you
drop the outer query, the order does appear to be maintained however.)
I'm using postgres 8.1.0.
Daniel T. Staal
---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Rodrigo E. De León Plicet | 2008-01-09 17:39:26 | Re: Order by sub-select |
Previous Message | Tom Lane | 2008-01-09 15:24:32 | Re: two postgres binaries |