Re: Weird misinterpretation of EXECUTE in PL/pgSQL

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> In the presence of a comma-separated list of arguments it seems to
> intepret the EXECUTE command wildly differently. What is going on here?

Basically it evaluates the string-producing argument by sticking SELECT
on the front and handing it to the main SQL engine. So what you've got
there is a SELECT that produces two result columns, where the EXECUTE
code was only expecting to get one. (Look at exec_eval_expr in pl_exec.c)

It's a syntax error in any case; not sure if we can easily produce a
better error message, or what a better error message would be.

regards, tom lane