From: | Edwin(dot)Ramirez at mssm(dot)edu (Edwin Ramirez) |
---|---|
To: | |
Subject: | [Pljava-dev] Array Support |
Date: | 2009-01-27 21:53:56 |
Message-ID: | 497F8274.8020300@mssm.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
I just started using PL/Java and it works very well. Compared to what
has to be done in Oracle to start creating functions in Java, it is 100
times easier.
In Oracle, I have functions like:
CREATE OR REPLACE FUNCTION count(match varchar,neg varchar,args vNum)
RETURN number deterministic as language java name
'whdpPkg.countMatch(java.lang.String, java.lang.String,oracle.sql.ARRAY)
return double';
Where "vNum" is a: CREATE OR REPLACE TYPE vNum as TABLE OF NUMBER;
Basically, an array of numbers (numerics).
Ideally in Postgres/PLJava I would like to:
CREATE OR REPLACE FUNCTION count(match varchar,neg varchar, args
numeric[]) RETURNS numeric as 'whdpPkg.countMatch(java.lang.String,
java.lang.String, ?????)' LANGUAGE java;
Is this possible? Is there a "oracle.sql.ARRAY" equivalent for Postgres?
What work is required to support something like this?
Thanks,
--
Edwin S. Ramirez, Senior Developer
Information Technology Department - ITDC
Mount Sinai Medical Center
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2009-01-28 09:23:27 | [Pljava-dev] Array Support |
Previous Message | Thomas Hallgren | 2009-01-14 21:44:00 | [Pljava-dev] project/wiki status? |