public inbox for [email protected]  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Array Support
Date: Tue, 27 Jan 2009 16:53:56 -0500
Message-ID: <[email protected]> (raw)

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Subject: Re: [Pljava-dev] Array Support
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox