Re: PQexecParams and types - Mailing list pgsql-performance

From Tom Lane
Subject Re: PQexecParams and types
Date
Msg-id 17666.1075819993@sss.pgh.pa.us
Whole thread Raw
In response to PQexecParams and types  (Czuczy Gergely <phoemix@harmless.hu>)
Responses Re: PQexecParams and types  (Czuczy Gergely <phoemix@harmless.hu>)
List pgsql-performance
Czuczy Gergely <phoemix@harmless.hu> writes:
> i've read in the docs to use the proper indexes both types must match in
> the where clause, to achive this the user can simply put a string into the
> side of the equation mark and pgsql will convert it automaticly. my
> question is, when I'm using PQexecParams, should I give all the values as
> a string, and it will be converted, or I have to figure out the type of
> the given field somehow?

You should leave the parameter types unspecified.  Their types will be
resolved in much the same way that a quoted literal is handled.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Rigmor Ukuhe"
Date:
Subject: Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
Next
From: Czuczy Gergely
Date:
Subject: Re: PQexecParams and types