Re: Prepared statements aren't working with parameters with PQexecParams

On Fri, Sep 5, 2008 at 2:52 AM, Subspace god <subspacegod(at)gmail(dot)com> wrote:

> The following does not work in C++, executed as above, in another session
> using two subsequent calls to PQexecParams
>
> PREPARE myquery (text) AS INSERT INTO myTable (word) VALUES ($1);
> EXECUTE myquery($1::text);

You're doing prepared statements incorrectly. Use PQprepare() and
PQexecPrepared() when using them from libpq; don't do them by hand on
your own.

--
- David T. Wilson
david(dot)t(dot)wilson(at)gmail(dot)com