pgTcl and Refcursors

[Philip A. Chapman]

Everyone,

I am about to begin a project which will use Java (JDBC) and postgresql.
In most Java projects, I do not embed SQL code, but create functions
which have the SQL logic. I call the functions from within my Java
code. For selects, the functions return refcursors, which the Java code
can get results from.

However, a seperate team is going to be using Tcl to do some rapid
prototyping. I would rather re-use as much of their work as possible.
If they also put all their SQL logic into functions, I can make my code
call the same functions. The question is, can Tcl process a resultset
provided as a refcursor by a function? I am not very familiar with Tcl,
and a scan of the PostgreSQL documentation's pgTcl section didn't seem
to provide an answer (at least to me).

Any help you provide would be appreciated.

Thanks,
--
Philip A. Chapman

Application Development:
Java, Visual Basic (MCP), PostgreSQL, MySQL, MSSQL
Linux, Windows 9x, Windows NT, Windows 2000, Windows XP

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBLMeRAdpynRSGw3URAnR5AJ48hVESnaeFzeUIbRvVd+ Q8oQdw/QCfbzJT
XP2aTCdsn21UsE8+mZdX2Kw=
=iB0w
-----END PGP SIGNATURE-----

[Tom Lane]

"Philip A. Chapman" <pc******@pcsw.us> writes:

The question is, can Tcl process a resultset
provided as a refcursor by a function?

Sure, just issue a FETCH command with the cursor name.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org