Re: Suggestion for parameterized queries

Sebastien FLAESCH wrote:
> Hi,
>
> Parameterized queries (PREPARE/EXECUTE), is a great thing, but it would
> even be better if the DECLARE CURSOR could use a PREPAREd statement, to
> declare a "server-side" cursor with a parameterized query, to use the
> benefits of DECLAREd cursors (no fetching of all the result set on the
> client, use the binary mode, use the scrollable option or the FOR UPDATE
> option).

> For now we cannot use DECLARE CURSOR in our PostgreSQL driver because
> of this limitation.... I could build the SQL statement with literal
> values, but since you have now parametrized queries I would prefer to
> use that...

You can define a function that returns a cursor, if that is of any use
to you.

--
   Richard Huxton
   Archonet Ltd