On Tue, 8 Mar 2005 ntinos@aueb.gr wrote:
> Hi everybody!
>
> I have an SRF which is called from a JAVA app with JDBC. Everything
> works fine and I want now to be able to pass some result-related info to
> my app. It is not about the format of the results (ResultSetMetaData) or
> something like that.
>
> Is it possible to return some string (or other type of)info together with
> the result tuples (even if it requiers some hacking i.e. there is no
> provision for something like that)? Any ideas?
>
The only idea that comes to mind is using RAISE NOTICE in your plpgsql
function and Statement or ResultSet .getWarnings() on the Java side to
retrieve that info. There really isn't any other out of band data path.
Kris Jurka