Re: expression evaluation with expected datatypes

Pavel Stehule <pavel.stehule@gmail.com> writes:
> When I worked on parametrised DO statement, I had to solve following issue:

> Syntax is:

> DO (param list) $$ ... $$ LANGUAGE ... USING expr_list

> What is correct way for evaluation of expr_list with specified target types?

I'd argue that that's a pointlessly unwieldy syntax that's creating an
unnecessary problem.  Just use a SELECT list, that is
DO ... USING value AS name, value2 AS name2, ...

The value expressions can define their own types just fine.
        regards, tom lane