> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
