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