Re: Is prepared cursored query possible? [Viruschecked]

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