Postgres Pro
Downloads
Home   >   mailing lists

Thread: no ORDER BY in subselects?

no ORDER BY in subselects?

From
Louis-David Mitterrand
Date:
auction=# SELECT (select b.lot from bid b where b.auction_id = a.id and b.person_id = buyer.id order by b.price limit
1)as last_lot,auction_status(a.id) > 0 AS current, a.lot, a.person_id, next_price(a.id), seller.mail AS seller_mail,
buyer.mailAS buyer_mail, seller.locale AS seller_locale, buyer.login AS buyer_login, num_bid(a.id), seller.login AS
seller_login,t.name AS auction_type FROM auction* a, person seller, person buyer, auction_type t WHERE a.id = 84 AND
seller.id= a.person_id AND COALESCE(a.type,1) = t.id AND buyer.id = 2;
 

ERROR:  parser: parse error at or near "order"

Aren't ORDER BY clauses allowed in subselects?

-- 
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org
              Black holes are where God divided by zero.

Re: no ORDER BY in subselects?

From
Philip Warner
Date:
At 15:23 20/09/00 +0200, Louis-David Mitterrand wrote:
>
>ERROR:  parser: parse error at or near "order"
>
>Aren't ORDER BY clauses allowed in subselects?
>

It is a very very sad fact, but, no, they're not.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/

Re: no ORDER BY in subselects?

From
Tom Lane
Date:
Louis-David Mitterrand <cunctator@apartia.ch> writes:
> Aren't ORDER BY clauses allowed in subselects?

No.  This is per SQL92...
        regards, tom lane