public inbox for [email protected]  

help / color / mirror / Atom feed

[Pljava-dev] Array Support
3+ messages / 0 participants
[nested] [flat]

* [Pljava-dev] Array Support
@ 2009-01-27 21:53 
  2009-01-28 09:23 ` [Pljava-dev] Array Support 
  0 siblings, 1 reply; 3+ messages in thread

From:  @ 2009-01-27 21:53 UTC (permalink / 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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] Array Support
  2009-01-27 21:53 [Pljava-dev] Array Support 
@ 2009-01-28 09:23 ` 
  2009-01-28 15:19   ` [Pljava-dev] Array Support 
  0 siblings, 1 reply; 3+ messages in thread

From:  @ 2009-01-28 09:23 UTC (permalink / raw)



On Tue, 27 Jan 2009, Edwin Ramirez wrote:

> 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?
>

I believe you want "java.math.BigDecimal[]".

Kris Jurka




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* [Pljava-dev] Array Support
  2009-01-27 21:53 [Pljava-dev] Array Support 
  2009-01-28 09:23 ` [Pljava-dev] Array Support 
@ 2009-01-28 15:19   ` 
  0 siblings, 0 replies; 3+ messages in thread

From:  @ 2009-01-28 15:19 UTC (permalink / raw)

Thanks for your reply.  I will try your suggestion and let you know how it goes.

Edwin S. Ramirez
              


----- Original Message -----
From: Kris Jurka <books at ejurka.com>
Date: Wednesday, January 28, 2009 4:24 am
Subject: Re: [Pljava-dev] Array Support
To: Edwin Ramirez <Edwin.Ramirez at mssm.edu>
Cc: pljava-dev at pgfoundry.org

> 
> 
> On Tue, 27 Jan 2009, Edwin Ramirez wrote:
> 
> > 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?
> >
> 
> I believe you want "java.math.BigDecimal[]".
> 
> Kris Jurka
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pljava-dev
> 





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2009-01-28 15:19 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2009-01-27 21:53 [Pljava-dev] Array Support 
2009-01-28 09:23 ` 
2009-01-28 15:19   ` 

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