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))
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