Re: receiving user defined types from a function?

On Tue, 23 Mar 2004, Dario Bahena wrote:

> hi ...
>
> I've a postgresql function, that returns a user defined composite type,
> is it posible to catch it using the jdbc driver???, cause then I tried
> it and saw the class for the object, it gave me just the first member
> for my composite type.
>

Instead of using a CallableStatement to call a function returning a
complex type the recommended method is to use a regular Statement or
PreparedStatement and simply call the function in a select such as:

SELECT * FROM mycomplexfunction('a',12);

Kris Jurka