On Sun, Dec 5, 2010 at 11:57, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > On 05.12.2010 12:10, Magnus Hagander wrote: >> >> On Sun, Dec 5, 2010 at 10:22, Marc Balmer<m...@msys.ch> wrote: >>> >>> I am suggesting adding a function to libpq: >>> >>> PGresult *PQvexec(PGconn *conn, const char *fmt, ...); >>> >>> It behaves similar to PQexec, but it allows for printf style varargs and >> >> How is that not a horrible idea, compared to using PQexecParams()? You >> have to remember to do all your escaping and things manually, whereas >> PQexecParams() does it automatically. > > A varargs version of PQexecParams() would be handy, though. Imagine being > able to do: > > PQexecVParams("SELECT * FROM mytable WHERE foo = $1 AND bar = $2", foovar, > barvar); > > instead of constructing an array for the variables.
I agree, that sounds a lot more useful. And if definitely needs to be split off from the auto-reconnection stuff. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers