Re: [SQL] Failing query...

2000-08-19 Thread Tom Lane
Shaun <[EMAIL PROTECTED]> writes: > SELECT a.auction_id, a.user_id, c.other_names, >c.surname, c.email, a.reserve, a.close_time, a.short_desc, >a.long_desc, a.start_time, >(COALESCE((select MAX(bid) from bid where auction_id = a.auction_id >group by auction_id), 0))

[SQL] Failing query...

2000-08-19 Thread Shaun
Hi All, I was hoping someone here would be able to help me with a query I have that is failing with the error: psql:query:1: ERROR: ExecEvalExpr: unknown expression type 501 The query is: SELECT a.auction_id, a.user_id, c.other_names, c.surname, c.email, a.reserve, a.close_time, a.sho