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






       

Reply via email to