Re: pass open cursor via USING in execute staement

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: domenico(dot)l76(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: pass open cursor via USING in execute staement
Date: 2023-06-01 14:23:44
Message-ID: 5c247f374cd29995f4161d02ed104c1052660509.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Wed, 2023-05-31 at 22:57 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/15/plpgsql-statements.html
>
> Should be documented if this statement is allowed or not (if not, maybe set
> as desired feature :-) )
>
> EXECUTE format('update %I set col1=$1, col2=now() WHERE current of $3',
> tabname)
>    USING myVal, myOpenCursor;

That is not supported. Parameters can only be used in a place where constants
(SQL literals) might appear, not instead of identifiers (names of tables, columns etc.)

I looked, and that is really not documented anywhere.
One of PREPARE or the extended query protocol might be good places.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Lorusso Domenico 2023-06-01 16:41:56 Re: pass open cursor via USING in execute staement
Previous Message PG Doc comments form 2023-05-31 22:57:52 pass open cursor via USING in execute staement