Re: Calling a stored procedure with a custom return type

On Thu, 25 Oct 2007, Brad Larson wrote:

> I'm sorry if this is already documented elsewhere; I've googled around
> and searched the jdbc source without any luck.  I have a stored
> procedure (PL/pgSQL) which uses a custom return type of the form:
>
> How can I call this from JDBC?  I can call it with a
>
> prepareStatement("select login( ?, ?, ?, ? )");
>
> but then the results are all returned as 1 string, of the form "(int,
> string, t, t)", which of course isn't ideal.  I also tried


SELECT * FROM login(?,?,?,?);

Kris Jurka