> This doesn't work:
> create function exc_using(varchar) returns varchar
> as $$
>  declare v varchar;
> begin
>   execute 'select upper($1)' into v using ('aa');

it cannot work. Your parameter is row. But
into v using 'aaa' doesn't work too :(

ERROR:  failed to find conversion function from unknown to text
CONTEXT:  SQL statement "select upper($1)"

you have to specify type: use argument, variable or casting
.... using text 'aaa'; or select upper($1::text)

It is question for Tom. Why prepared statement cannot cast from literal to text

> I also noted that the patch makes USING a keyword. Not sure if we care
> about that or not.
I am afraid to change well know syntax (SQL/PSM use it in same context too).


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to