Re: libpq and prepared statements progress for 8.0 - Mailing list pgsql-hackers

> Anyone working on the libpq interface to prepared statements?
> We could really use that for DBD::Pg. Alternatively, if someone
> knows a trick to prepare an INSERT statement without knowing
> the data types, that would be neat too. For example:
>
> CREATE TABLE foobar(a INTEGER);
>
> These don't work:
>
> PREPARE st(text) AS INSERT INTO foobar(a) VALUES ($1);
>
> PREPARE st(unknown) AS INSERT INTO foobar(a) VALUES ($1);
>
> PREPARE st(unknown) AS INSERT INTO foobar(a) VALUES ($1::unknown);

Using PQExecParams is completely out of the question?  How are you
executing your statements...PQExec?

Merlin