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

Поиск
Список
Период
Сортировка
От
Тема Re: JDBC - Call stored function that returns user defined type
Дата
Msg-id A0ACCC9851F24342B9E40D0F5A76ABD6@nc05072019
обсуждение исходный текст
Ответ на PostgreSQL 8.3.4 Solaris x86 compilation issues  ("Dot Yet" <dot.yet@gmail.com>)
Список pgsql-general
Дерево обсуждения
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 -----
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
 
 
 
 
 

       

В списке pgsql-general по дате отправления: