Pavel Stehule <pavel.steh...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
