| From: | Susan M Farley <sfarley1(at)gmu(dot)edu> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Function Error |
| Date: | 2010-02-23 14:58:45 |
| Message-ID: | fcc1a5ce16147.4b83a6d5@gmu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I'm trying to import a function in Java, but am having problems with it. The java function is
public static double chi2cdf (double x)
{
return chi.cdf(x);
}
I copied the sim.class file to the Postgres data directory and I added it to Postgres with the following
select sqlj.replace_jar('file:///D:/workspace/SimplePrediction/sim.jar','sim',true);
SELECT sqlj.set_classpath('public', 'sim');
CREATE OR REPLACE FUNCTION sim.chi2cdf(double precision)
RETURNS double precision
AS 'simpleMonteCarlo.sim.chi2cdf'
LANGUAGE java;
When I try to run it, I get the following error:
ERROR: Unable to find static method simpleMonteCarlo.sim.chi2cdf with signature (D)D
I thought it was the signature of double precision, but then tried it with two other functions, one a float and one a int. Does anyone have any ideas?
Thank you,
Susan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2010-02-23 15:06:39 | Re: SET Role doesn't work from Security Definer Function... |
| Previous Message | Richard Huxton | 2010-02-23 11:55:15 | Re: Minor systax error but not able to resolve it... |