pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedCan you bind output variables?
4+ messages / 4 participants
[nested] [flat]
* Can you bind output variables?
@ 2005-02-08 06:18 Mark Crosland <mjc@comcast.net>
0 siblings, 0 replies; 4+ messages in thread
From: Mark Crosland @ 2005-02-08 06:18 UTC (permalink / raw)
To: pgsql-interfaces
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,
^ permalink raw reply [nested|flat] 4+ messages in thread
* Can you bind output variables?
@ 2005-02-08 23:27 mjc@comcast.net
2005-02-09 04:49 ` Re: Can you bind output variables? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: mjc@comcast.net @ 2005-02-08 23:27 UTC (permalink / raw)
To: pgsql-interfaces
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,
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can you bind output variables?
2005-02-08 23:27 Can you bind output variables? mjc@comcast.net
@ 2005-02-09 04:49 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2005-02-09 04:49 UTC (permalink / raw)
To: mjc@comcast.net; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Can you bind output variables?
@ 2005-02-09 13:46 Goulet, Dick <DGoulet@vicr.com>
0 siblings, 0 replies; 4+ messages in thread
From: Goulet, Dick @ 2005-02-09 13:46 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; mjc@comcast.net; +Cc: pgsql-interfaces
But the method that libpq has for returning data is, I believe, much
more friendly than other DBMS's. Try using Oracle's SQLDA, it's a lot
more complicated. Although once setup it works well.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, February 08, 2005 11:49 PM
To: mjc@comcast.net
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Can you bind output variables?
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
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-02-09 13:46 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-02-08 06:18 Can you bind output variables? Mark Crosland <mjc@comcast.net>
2005-02-08 23:27 Can you bind output variables? mjc@comcast.net
2005-02-09 04:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-02-09 13:46 Re: Can you bind output variables? Goulet, Dick <DGoulet@vicr.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox