X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id BD9C7D1B57C for ; Tue, 3 Feb 2004 07:25:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81015-09 for ; Tue, 3 Feb 2004 03:25:41 -0400 (AST) Received: from marvin.harmless.hu (marvin.harmless.hu [195.70.51.173]) by svr1.postgresql.org (Postfix) with ESMTP id 10024D1B53C for ; Tue, 3 Feb 2004 03:25:41 -0400 (AST) Received: from marvin.harmless.hu (marvin.harmless.hu [195.70.51.173]) by marvin.harmless.hu (Postfix) with ESMTP id DDFE31000118B for ; Tue, 3 Feb 2004 08:25:38 +0100 (CET) Date: Tue, 3 Feb 2004 08:25:38 +0100 (CET) From: Czuczy Gergely X-X-Sender: phoemix@localhost To: pgsql-performance@postgresql.org Subject: PQexecParams and types Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/32 X-Sequence-Number: 5556 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.