Re: Planner weakness (was: Re: ExecEvalExpr: unknown expression type 108)

"=?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