On Tue, 8 Mar 2005 [EMAIL PROTECTED] 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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to