From: Tom Lane <tgl@sss.pgh.pa.us>
To: Markus Bertheau <twanger@bluetwanger.de>
Cc: postgres sql list <pgsql-sql@postgresql.org>
Cc: Horst Schwarz <schwarz@bab24.de>
Subject: Re: ERROR: ExecEvalExpr: unknown expression type 108
Date: Mon, 30 Jun 2003 12:50:49 -0400
Message-ID: <15395.1056991849@sss.pgh.pa.us> (raw)
In-Reply-To: <1056989417.2297.25.camel@fluor>
References: <1056989417.2297.25.camel@fluor>
Markus Bertheau <twanger@bluetwanger.de> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, twanger@bluetwanger.de, schwarz@bab24.de
Subject: Re: ERROR: ExecEvalExpr: unknown expression type 108
In-Reply-To: <15395.1056991849@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox