I have a plpgsql function that takes a numeric parameter. It is for a
price in a table. The table has the price declared as numeric(10,2),
and the function parameter is just numeric. However in Java I have the
price represented as a double.
Using jdbc setDouble for a parameter for the function causes causes an
ERROR saying that the function taking a double precision parameter does
not exist (which is obviously correct).
What do other people do?
Is there a way to pass a numeric parameter through JDBC?
Should the parameter to the function be a double which is the "cast"
into the numeric inside the function?
Your ideas are welcome.
pgsql-jdbc by date
|Next:||From: Dave Cramer||Date: 2004-09-15 12:36:09|
|Subject: Re: Calling functions with numeric parameters|
|Previous:||From: Kris Jurka||Date: 2004-09-15 05:36:18|
|Subject: Re: Customizing SSL with jdbc|