From: | thomas at tada(dot)se (Thomas Hallgren) |
---|---|
To: | |
Subject: | [Pljava-dev] Custom java objects |
Date: | 2006-08-14 22:44:49 |
Message-ID: | 44E0FCE1.6020609@tada.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
Hi Maxim,
You should be able to do this by just installing a custom type mapping for type 'a'. See:
http://wiki.tada.se/wiki/display/pljava/Mapping+an+SQL+type+to+a+Java+class
Regards,
Thomas Hallgren
Maxim wrote:
> Hello,
>
> I try to write aggregate function in Java for PostgeeSQL 8.1.
>
> I just want to know, are there any ways to pass custom java objects
> thorough iterations of row handler?
>
> For example, I have functions in PostgreSQL (a is a table):
>
> CREATE FUNCTION handler1(a, a)
> returns a
> as 'functions.handler1'
> immutable language java;
>
> CREATE FUNCTION handler2(a)
> returns a
> as 'functions.handler2'
> immutable language java;
>
> CREATE AGGREGATE aa ( BASETYPE = a, SFUNC = handler1, STYPE = a, FINALFUNC = handler2);
>
>
> And two functions in Java:
>
> public static boolean handler1(ResultSet a, ResultSet record, ResultSet result) throws Exception {
> int v = a == null ? Integer.MIN_VALUE : a.getInt(1);
> if (record.getInt(1) > v) {
> result.updateInt(1, record.getInt(1));
> result.updateString(2, record.getString(2));
> } else {
> result.updateInt(1, a.getInt(1));
> result.updateString(2, a.getString(2));
> }
> return true;
> }
>
> public static boolean handler2(ResultSet a, ResultSet result) throws Exception {
> if (a == null) return false;
> result.updateInt(1, a.getInt(1));
> result.updateString(2, a.getString(2));
> return true;
> }
>
>
> I Just want to use custom java object instead of "ResultSet a".
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Hallgren | 2006-08-14 22:49:48 | [Pljava-dev] CREATE FUNCTION docs inconsistent with implementation |
Previous Message | Thomas Hallgren | 2006-08-14 22:41:17 | [Pljava-dev] Possible to override default type mappings? |