Re: [GENERAL] SRF, JDBC and result info

[ntinos]

Thank you very much for your reply. The thing is that my SRF is written in 
C, not plpgsql, but I'll look into RAISE NOTICE anyway.(I think there is 
something equevalent in libpq) 

Thanks again,
Ntinos Katsaros 

Kris Jurka writes: 

 

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faq