Message-ID: <001a01c2cad9$044a5710$6401a8c0@spook>
From: "John Cavacas" <oogly@rogers.com>
To: <pgsql-sql@postgresql.org>
References: <000d01c2cad1$eb3a7e50$6401a8c0@spook>
	<20030202155241.GA5672@serwer>
Subject: Re: How to return records from a function
Date: Sun, 2 Feb 2003 11:34:54 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Thanks!

That's somewhat of what i was looking for. However it seems that what I
wanted to do is still not possible.

I'm writing a Java application and wanted to use CallableStatement to call a
PostgreSQL function. However it seems that the driver does not implement
that functionality. I guess I can just use a regular statement calling a
function but there seems to be problems doing that as well. Are there any
other JDBC drivers for PostgreSQL?

Thanks,
john


----- Original Message -----
From: <jasiek@serwer.skawsoft.com.pl>
To: "John Cavacas" <oogly@rogers.com>
Cc: <pgsql-sql@postgresql.org>
Sent: February 2, 2003 10:52 AM
Subject: Re: [SQL] How to return records from a function


> Did you look at
> http://techdocs.postgresql.org/guides/SetReturningFunctions
> ? You need Postgresql 7.3 to do this.
> Regards,
> Tomasz Myrta