Thread: Is prepared cursored query possible?

Hello folks,

I'm improving the capabilities of the JDBC driver of Postgres at the moment;
only one problem:
I tried to "declare curs_4711 cursor for execute prep_0815;" and get an error
message for the execute inside the statement.
As I refer to the docs, they say only select is possible, which seems illogical
to me. Is that intended or just a parser inability/grammar inability?
Or is there a workaround for that? (maybe a select from ... thingy?)

tia

Patric

"Patric Bechtel" <bechtel@ipcon.de> writes:
> As I refer to the docs, they say only select is possible, which seems
> illogical to me.

Why?  A cursor has to have some rows to read, ISTM.  Putting INSERT or
UPDATE or DELETE in it would make no sense.

            regards, tom lane

On Wed, 01 Jan 2003 23:22:11 -0500, Tom Lane wrote:

>"Patric Bechtel" <bechtel@ipcon.de> writes:
>> As I refer to the docs, they say only select is possible, which seems
>> illogical to me.
>
>Why?  A cursor has to have some rows to read, ISTM.  Putting INSERT or
>UPDATE or DELETE in it would make no sense.
>
>            regards, tom lane
>
>
That's not the point. I want to prepare a query, like
"prepare myplan(bigint) as select * from adresses where id=$1"
and then
"declare mycurs cursor as execute myplan(47110815)"

That's not possible, as I have to put the source query
behind the cursor declaration.
I WOULD understand when declare failed on prepared
update, delete or insert statements, kind of at least.
But no prepared queries at all?

tia

Patric