Re: pass open cursor via USING in execute staement

2023-06-06 Thread Kirk Wolak
On Thu, Jun 1, 2023 at 9:32 AM PG Doc comments form wrote: > 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

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

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