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 - [EMAIL PROTECTED] - http://www.apartia.org
Black holes are where God divided by zero.
