Re: Basic questions about PQprepare()

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Alexander Farber <alexander(dot)farber(at)gmail(dot)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.