Skip site navigation (1) Skip section navigation (2)

no ORDER BY in subselects?

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-sql(at)postgresql(dot)org
Subject: no ORDER BY in subselects?
Date: 2000-09-20 13:23:04
Message-ID: 20000920152303.A3939@styx (view raw or flat)
Thread:
Lists: pgsql-sql
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.mail AS 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(at)apartia(dot)org - http://www.apartia.org

               Black holes are where God divided by zero.

Responses

pgsql-sql by date

Next:From: Louis-David MitterrandDate: 2000-09-20 13:25:52
Subject: ERROR: replace_vars_with_subplan_refs (!?)
Previous:From: Louis-David MitterrandDate: 2000-09-20 06:44:26
Subject: Re: sum of agreggates in one SELECT?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group