[Pljava-dev] A couple PL/Java questions

[Thomas Hallgren]

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