pass open cursor via USING in execute staement

2023-06-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/plpgsql-statements.html Description: 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()

Re: pass open cursor via USING in execute staement

2023-06-01 Thread Laurenz Albe
On Wed, 2023-05-31 at 22:57 +, 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

Re: pass open cursor via USING in execute staement

2023-06-01 Thread Lorusso Domenico
Yes, I agree, but also in cursor page. Talking about cursor I can't find example that shows how pass a bounded cursor to a function or procedure (must be already open? must be declared in some specific way?) Il giorno gio 1 giu 2023 alle ore 16:23 Laurenz Albe < laurenz.a...@cybertec.at> ha scritt