Home > mailing lists

JDBC - Call stored function that returns user defined type - Mailing list pgsql-general

From
Subject	JDBC - Call stored function that returns user defined type
Date	October 24, 2008 19:22:33
Msg-id	71AF69113F86450DB0BDBC6B511F50E3@nc05072019 Whole thread Raw
In response to	PostgreSQL 8.3.4 Solaris x86 compilation issues ("Dot Yet" <dot.yet@gmail.com>)
List	pgsql-general

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

From: "mike stanton"
Date: 24 October 2008, 19:12:34
Subject: Order by with spaces and other characters

From: Tomasz Myrta
Date: 24 October 2008, 20:32:36
Subject: Re: How to get user list and privileges?