From: Czuczy Gergely <phoemix@harmless.hu>
To: pgsql-performance@postgresql.org
Subject: PQexecParams and types
Date: Tue, 3 Feb 2004 08:25:38 +0100 (CET)
Message-ID: <Pine.LNX.4.44.0402030822001.19142-100000@localhost> (raw)
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@harmless.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: phoemix@harmless.hu
Subject: Re: PQexecParams and types
In-Reply-To: <Pine.LNX.4.44.0402030822001.19142-100000@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox