From: | "Philip A(dot) Chapman" <pchapman(at)pcsw(dot)us> |
---|---|
To: | Pgsql-General <pgsql-general(at)postgresql(dot)org> |
Subject: | pgTcl and Refcursors |
Date: | 2004-08-25 17:08:25 |
Message-ID: | 412CC789.5090501@pcsw.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chris M. Gamble | 2004-08-25 17:35:16 | Timestamp with Timezone |
Previous Message | Jan Wieck | 2004-08-25 16:58:49 | Re: Unsupported 3rd-party solutions (Was: Few questions |