Re: expression evaluation with expected datatypes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: expression evaluation with expected datatypes
Date
Msg-id 3924.1341763223@sss.pgh.pa.us
Whole thread Raw
In response to expression evaluation with expected datatypes  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: expression evaluation with expected datatypes  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Joel Jacobson
Date:
Subject: Re: Schema version management
Next
From: Pavel Stehule
Date:
Subject: Re: expression evaluation with expected datatypes