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

[cyw]

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: [EMAIL PROTECTED] 
  To: General PostgreSQL List 
  Sent: Friday, October 24, 2008 2:23 PM
  Subject: [GENERAL] 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