From: Kris Jurka <books@ejurka.com>
To: Dario Bahena Tapia <dario@ciencias.unam.mx>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: receiving user defined types from a function?
Date: Fri, 26 Mar 2004 16:31:34 -0500 (EST)
Message-ID: <Pine.BSO.4.56.0403261629490.3597@leary.csoft.net> (raw)
In-Reply-To: <4060CE01.9080800@bsantander.com.mx>
References: <4060CE01.9080800@bsantander.com.mx>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: books@ejurka.com, dario@ciencias.unam.mx
Subject: Re: receiving user defined types from a function?
In-Reply-To: <Pine.BSO.4.56.0403261629490.3597@leary.csoft.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox