Re: SRF, JDBC and result info

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 ntinos(at)aueb(dot)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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster