Re: Basic questions about PQprepare() - Mailing list pgsql-general

From Alexander Farber
Subject Re: Basic questions about PQprepare()
Date
Msg-id 943abd910601281126g1851878bl2294910dfc8eacd4@mail.gmail.com
Whole thread Raw
In response to Re: Basic questions about PQprepare()  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Basic questions about PQprepare()  (Joachim Wieland <joe@mcknight.de>)
List pgsql-general
Thank you Tom,

I also should have reread the docs on 1) and 2) -
it is mentioned there too that you have to call
PQfinish and PQclear even on failed operations.

Could you explain a bit more, where to get the OIDs?
There are really not many PQprepare examples
around (I wonder why, isn't it the fastest method?)

Regards
Alex

On 1/28/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alexander Farber <alexander.farber@gmail.com> writes:
> > 4) How do I set the last PQprepare argument, the const Oid *paramTypes?
>
> You'd need to look up the OIDs of the parameter types.  In practice it's
> usally a lot easier to write the queries so that the parameter types can
> be inferred by the backend.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Viewing Database Scheme
Next
From: "Raymond O'Donnell"
Date:
Subject: Re: Seeking a better PL/pgSQL editor-debugger