X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 328363106C5 for ; Mon, 30 Jun 2003 16:51:05 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 21768-06 for ; Mon, 30 Jun 2003 13:50:54 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 79A1131082F for ; Mon, 30 Jun 2003 13:50:54 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h5UGonQQ015397; Mon, 30 Jun 2003 12:50:49 -0400 (EDT) To: Markus Bertheau Cc: postgres sql list , Horst Schwarz Subject: Re: ERROR: ExecEvalExpr: unknown expression type 108 In-reply-to: <1056989417.2297.25.camel@fluor> References: <1056989417.2297.25.camel@fluor> Comments: In-reply-to Markus Bertheau message dated "30 Jun 2003 18:10:18 +0200" Date: Mon, 30 Jun 2003 12:50:49 -0400 Message-ID: <15395.1056991849@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200306/341 X-Sequence-Number: 14099 Markus Bertheau writes: > PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 > datetest=# select * from (select (select count(1) from (select von from > daten union select bis as von from daten) as d1 where d1.von < d2.von) > as number, von from (select von from daten union select bis as von from > daten) d2) as bar join (select (select count(1)+1 from (select von from > daten union select bis as von from daten) as d1 where d1.von < d2.von) > as number, von from (select von from daten union select bis as von from > daten) d2) as foo using (number); > ERROR: ExecEvalExpr: unknown expression type 108 7.3 has a problem with subselects referenced as join outputs. There is a fix in 7.3.1, and a better fix in place for 7.4. regards, tom lane