Re: JDBC - Call stored function that returns user defined type
От
Тема
Re: JDBC - Call stored function that returns user defined type
Дата
Msg-id
A0ACCC9851F24342B9E40D0F5A76ABD6@nc05072019
Список
Дерево обсуждения
Re: JDBC - Call stored function that returns user defined type <cyw@dls.net>
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 по дате отправления
