Search Postgresql Archives

JDBC - Call stored function that returns user defined type

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
 
 
 
 
 

       

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux