Joshua D. Drake wrote:
> Mostly, I think you will find that the back end developers aren't fond
> of Java and thus, it doesn't get much love.
>
> There is a reason that plPerl is king in this community (and I don't
> even like Perl).
>
yeah, understood. I'm getting the request 2nd hand, from someone in a
TZ 14 hours different than my own (big company, many left hands)... so
info is trickling to me.
apparently the requester is comfortable programming in Java, and needs
to do some sorta-statistical calculations inside a function used in a
join of some 73 columns, which will get used by some reporting
software... the database in question was ported from a different rdbms
where this was a single flat table rather than a several way join, and
... well... thats all I know so far.
I've already suggested plpgsql and/or plperl.
I'm going to take a stab at building the CVS head of pljava on solaris
sparc 64bit tonight or tomorrow. it appears the 64bit community
builds of PG 8.4 were built with sunstudio 11, pg_config lists
....
CC = /net/grok/ontools/onnv-tools/SUNWspro/SS11/bin/cc
CPPFLAGS = -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include
-I/usr/sfw/include -I/usr/include/libxml2
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include
CFLAGS = -xO3 -xarch=v9 -dalign -Wc,-Qiselect-regsym=0 -xspace
-W0,-Lt -W2,-Rcond_elim -Xa -xildoff
CFLAGS_SL = -KPIC
LDFLAGS = -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64 -L/usr/sfw/lib/64
-L/usr/lib -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/usr/lib/64 -L/usr/sfw/lib/64 -Wl,-R'/usr/postgres/8.4-community/lib/64'
It appears I have Sun C 5.9 at my disposal, not sure which version of
sunstudio this is from.
$ /opt/SUNWspro/bin/cc -V
cc: Sun C 5.9 SunOS_sparc Patch 124867-12 2009/11/22
wish me luck :)