| From: | Czuczy Gergely <phoemix(at)harmless(dot)hu> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | PQexecParams and types |
| Date: | 2004-02-03 07:25:38 |
| Message-ID: | Pine.LNX.4.44.0402030822001.19142-100000@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello
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? i'm writing an interface for my php extension(i'm
not statisfied by the boundled), so i cannot figure out the type of the
fields in most cases. what should be done for the best performance in this
situation?
Bye,
Gergely Czuczy
mailto: phoemix(at)harmless(dot)hu
PGP: http://phoemix.harmless.hu/phoemix.pgp
The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Brown | 2004-02-03 10:57:46 | Re: COPY from question |
| Previous Message | Erki Kaldjärv | 2004-02-03 07:03:05 | Re: inserting large number of rows was: Re: Increasing |