[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

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

Re: [SQL] Tuple size limit.

2000-08-19 Thread Tom Lane
Christopher Sawtell <[EMAIL PROTECTED]> writes: > I understand that the 7.1 release currently in CVS does not have this > limitation. So I'd like to know if this 7.1 release is imminent; > i.e. < ~2 to 3 months? If it's not out in <3 months, you won't be the only person who's very unhappy ;-). I