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