Re: [GENERAL] SRF, JDBC and result info

2005-03-11 Thread ntinos
Solution found! Thanks to Kris Jurka's advise I managed to pass this info using: elog(INFO,... or elog(NOTICE,... . These messages together with .getWarnings() do the job. : e.g. message returned by the SQLWarning: SNOTICEC0M#SUCCESSFUL EXECUTION. NO TUPLES FROM PEER(S):

Re: [GENERAL] SRF, JDBC and result info

2005-03-10 Thread Kris Jurka
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

Re: [GENERAL] SRF, JDBC and result info

2005-03-10 Thread 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!

[GENERAL] SRF, JDBC and result info

2005-03-08 Thread ntinos
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