Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF

Sebastien FLAESCH <sf@4js.com> writes:
> Does a simple PQPrepare() with a SELECT statement not create a cursor on
> the server side?

No.  A prepared statement is just a query plan, not a query-in-progress.

The Bind/Execute messages sent by PQexecPrepared create something akin
to a cursor, but libpq doesn't expose any API for fetching one row at a
time in that context, so there's no way to use the "current row" anyway.
        regards, tom lane