Is prepared cursored query possible?

From: "Patric Bechtel" <bechtel(at)ipcon(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Is prepared cursored query possible?
Date: 2003-01-01 23:50:30
Message-ID: 20030101235043.52EAA4759BD@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-01-02 04:20:34 Re: creating languages in the pg_catalog schema?
Previous Message Jochem van Dieten 2003-01-01 23:32:44 Re: creating languages in the pg_catalog schema?