X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E6A4E52918 for ; Fri, 3 Jun 2005 16:29:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72538-10 for ; Fri, 3 Jun 2005 19:29:20 +0000 (GMT) Received: from brasil.brainstorm.fr (brasil.brainstorm.fr [193.56.58.33]) by svr1.postgresql.org (Postfix) with ESMTP id 75683528CB for ; Fri, 3 Jun 2005 16:29:19 -0300 (ADT) Received: by brasil.brainstorm.fr (Postfix, from userid 1005) id DCB8926AF46; Fri, 3 Jun 2005 21:29:19 +0200 (CEST) Content-Type: text/plain; charset="iso-8859-15" Content-Disposition: inline Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Mailer: Manitou v0.9.6 From: "Daniel Verite" Subject: Re: libpq, PQExecParams and the inserting of binary data To: "David Hinkle" Cc: pgsql-interfaces@postgresql.org In-Reply-To: Date: Fri, 03 Jun 2005 21:29:14 +0200 Message-Id: <20050603212513.1148667@localhost> X-Face: 0N#]; "Miw2ss`WySq(ZLLy[=.ai4D}yI#'n*PU:{%/ZVSUd*G$EuN$v@TyBnpW5x=-m*Jc?Cm&=kXN#l; pePLb!,P.9D4M]fHU+XMPTe(>>'( X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.02 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/18 X-Sequence-Number: 5586 David Hinkle wrote: > Is it neccissary to provide the OID of the other fields even though > they're provided in text format? I guess what I really need to > understand is what the OID field is and how to use it. As far as I understand, no it's not necessary. 0 instead of an OID in the paramTypes array is fine for any parameter as long as the type of this parameter can be correctly guessed by the server at execution time. -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org