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 -----From: cyw@dls.netSent: Friday, October 24, 2008 2:23 PMSubject: [GENERAL] JDBC - Call stored function that returns user defined typeI 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 aCallableStatement, 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 по дате отправления: