I am looking for info on how to call a stored function that returns a user
defined type.
Assume I have a type defined as:
CREATE TYPE XYType AS (x int4, y int4);
and I use CYType in a function such as this:
CREATE FUNCTION test(IN z int4, OUT xy XYType, OUT status character)
RETURNS RECORD AS $BODY$.....
I found info on how to formulate a CallableStatement, but no info on how to
process the results from the call? Or does Postgres JDBC support this type of
calls?
Any help is greatly appreciated.
Regards,
CYW