Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can you bind output variables?

Can you bind output variables?

From
mjc@comcast.net
Date:
Hello,

Can you use paramValues[] in either PQexecParams or PQexecPrepared to read
data from the DB into the bound variables?

Or can you only bind input values? And all output must be read by iterating
over rows and columns using PQgetvalue() ?

Thanks,
Mark,

Re: Can you bind output variables?

From
Tom Lane
Date:
mjc@comcast.net writes:
> Can you use paramValues[] in either PQexecParams or PQexecPrepared to read 
> data from the DB into the bound variables?

Nope, those are input values only.  Maybe you should be looking at ecpg
--- "bound variables" is an idea completely foreign to libpq.
        regards, tom lane