Re: Planner weakness (was: Re: ExecEvalExpr: unknown expression type 108) - Mailing list pgsql-general

From Tom Lane
Subject Re: Planner weakness (was: Re: ExecEvalExpr: unknown expression type 108)
Date
Msg-id 6005.1039702787@sss.pgh.pa.us
Whole thread Raw
In response to Planner weakness (was: Re: ExecEvalExpr: unknown expression type 108)  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Responses Re: Planner weakness (was: Re: ExecEvalExpr: unknown expression type  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu> writes:
> -- #2. This throws an error:
> tir=> (SELECT
> tir(>     (SELECT az_jel from x where az=t.x) as x_az_jel
> tir(> FROM t_item t
> tir(> WHERE -- snip...
> tir-> ORDER BY t.az_jel, t.teljesites;
> ERROR: ExecEvalExpr: unknown expression type 108

You have not mentioned what PG version you are using, but if it's 7.3,
this is a known bug already fixed for 7.3.1.  The patch was posted here
a week ago.

            regards, tom lane

pgsql-general by date:

Previous
From: "James F"
Date:
Subject: Re: Is it possible to Import tables and its data from Ms Access
Next
From: Thomas Beutin
Date:
Subject: Re: INDEX suggestion needed