Re: JDBC - Call stored function that returns user defined type

<cyw@xxxxxxx> · Sat, 25 Oct 2008 14:29:26 -0500

While I still don't know who to handle returns with 
scalars and user defined types mixes, I tested with a function that returns only 
a SETOF a user defined type, the behavior is the same as a normal select 
return. You can use ReseultSet to traverse and get each column. 

CYW

  ----- Original Message ----- 
  From: 
  cyw@xxxxxxx 
  To: General PostgreSQL List 
  Sent: Friday, October 24, 2008 2:23 
  PM
  Subject:  JDBC - Call stored 
  function that returns user defined type

  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