From: thhal at mailblocks.com (Thomas Hallgren)
Date: Sat, 21 May 2005 08:31:37 +0200
Subject: [Pljava-dev] A couple PL/Java questions
In-Reply-To: <428E6563.7050508@bonbon.net>
References: <428E6563.7050508@bonbon.net> <428ED5C9.3020507@mailblocks.com>
	<thhal-0TG5qA6nPzTYN/K7QL3pmPQ9Uospvns@mailblocks.com>
Message-ID: <thhal-0TG5qA6vPzTYnuGBkokrxOkXUfpGUs4@mailblocks.com>

Eric E wrote:

> Hi,
>    I've been looking at PL/Java, and I'm pretty impressed so far.  I'm 
> still unclear on a couple things:
> 1) Is is possible to write Java code directly embedded in the function 
> are is all code in .jar files found in the classpath?

All code is in .jar files. Anything else would require a full blown Java 
parser/compiler.

> 2) Is it possible to write a PL/Java function that returns a tuple 
> with the number of of elements determined at runtime (to be used with 
> a SELECT * from myfunc(arg);  )?

Yes, you can write a function that returns SETOF RECORD.

Regards,
Thomas Hallgren