Not that i can see. The declare’d query isn’t shown to accept $n bindings rather it must be executable (select or values). Per the note on declare, the bind phase of the fetch command under the extended protocol is used to determine whether values retrieved are text or binary. Beyond that, the bind is really just a formality of the protocol, the same as for executing any other non-parameterized query that way.
Seems you can bind to the Declare though.
Right. You got me trying to equate cursors and prepared statements and they differ in exactly this way. The prepared binds are held until execute while cursor binds, and query execution for that matter, are immediate, with fetch just being a way to obtain the rows already computed (at least conceptually, optimizations might exist). They both end up creating a named portal. You cannot declare an execute command which simplifies things a bit.
