Using RECORD returning functions with JDBC

From: Juan Francisco Diaz <j-diaz(at)publicar(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Using RECORD returning functions with JDBC
Date: 2003-08-25 22:48:21
Message-ID: BB6FFC65.B3%j-diaz@publicar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi, now I know that in order to call a SETOF RECORD function i have to put
something like:
Select foo(param1,param2) as (ccolname1,colname2)

Now I am using JDBC and CallableStatement.
How should I give the column name list so that the function works ok?
Suppose i have the foo function that returns a SETOF RECORD and a callable
statement c.

Thanks a lot!

JuanF
(A newbie in evolution!)

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Juan Francisco Diaz 2003-08-25 23:37:59 Converting VARCHAR to DECIMAL or NUMERIC
Previous Message CoL 2003-08-25 21:09:37 Re: Way to tell what SQL is currently running?