Received: from clubserv.rp-online.de (root@clubserv.rp-online.de [149.221.232.11]) by hub.org (8.9.1/8.9.1) with ESMTP id NAA29530 for ; Wed, 18 Nov 1998 13:59:12 -0500 (EST) (envelope-from meskes@usa.net) Received: from feivel.meskes.de (as10-asy28.rp-plus.de [149.221.92.220]) by clubserv.rp-online.de (8.9.1a/8.9.1) with ESMTP id TAA20897 for ; Wed, 18 Nov 1998 19:59:31 +0100 (MET) Received: (from meskes@localhost) by feivel.meskes.de (8.9.1a/8.9.0/Debian/GNU) id IAA00879 for pgsql-hackers@hub.org; Wed, 18 Nov 1998 08:47:43 +0100 Date: Wed, 18 Nov 1998 08:47:43 +0100 From: Michael Meskes To: pgsql-hackers@hub.org Subject: Re: [HACKERS] PREPARE Message-ID: <19981118084743.A869@usa.net> Mail-Followup-To: pgsql-hackers@hub.org References: <19981117101824.C2181@usa.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.94.15i In-Reply-To: ; from Peter T Mount on Tue, Nov 17, 1998 at 06:40:01PM +0000 On Tue, Nov 17, 1998 at 06:40:01PM +0000, Peter T Mount wrote: > it has each required parameter represented by a ? > > insert into mytable (field1,field2,field3) values (?,?,?); > > Now the current postgresql jdbc implementation stores this string, and has > a Vector (Java for a dynamic array) that has each value stored in it as > the client application sets them. When the client calls the > executeUpdate() or executeQuery() methods, we just replace the ?'s with > the values in sequence, and pass the query to the backend as normal. That's exactly what I wanted to use for ecpg. But I guess I postpone it just a little more. :-) Michael -- Dr. Michael Meskes, Manager of the Western Branch Office, Datenrevision GmbH work: Cuxhavener Str. 36, D-21149 Hamburg home: Th.-Heuss-Str. 61, D-41812 Erkelenz, Michael.Meskes@usa.net Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!