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 <[EMAIL PROTECTED]> wrote:
> Alexander Farber <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to