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
