Re: Problem catching multiple values

On Tue, 24 May 2005 hiuguis@iteso.mx wrote:

>     Im having an problem when I try to catch multiple values from an SETOF
> float8 pgsql function invoked from java. This is the message that I get:

CallableStatements cannot be used for SETOF functions, only refcursor
returning functions.  It is best to call this with a normal
PreparedStatement or Statement that returns a ResultSet in the standard
fashion:  SELECT * FROM mysrf();

Kris Jurka