Re: [HACKERS] libpq and prepared statements progress for 8.0

[David Wheeler]

On Sep 19, 2004, at 9:13 PM, Abhijit Menon-Sen wrote:

OK, how about adding a PQprepare (PQcreatePrepared?) function like this?

    PGresult *
    PQprepare(PGconn *conn,
              const char *stmtName,
              const char *query,
              int nParams,
              const Oid *paramTypes)
    {
        ...

PQprepare would construct a Parse message to create a prepared statement
named stmtName from the given query, with nParams types pre-declared. It
could be called by DBD::Pg with nParams == 0 to let the server infer all
of the parameter types.

Sounds damn good to me, Abhihit, thanks!

I suppose an asynchronous equivalent would also be needed.
(Yes, I'm volunteering to write both functions.)

Woot! :-)

Regards,

David

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster