Re: [HACKERS] PREPARE

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(dot)Meskes(at)usa(dot)net
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!