Calling functions with numeric parameters
| От | Tim Penhey |
|---|---|
| Тема | Calling functions with numeric parameters |
| Дата | |
| Msg-id | 41482F1C.4060503@penhey.net обсуждение исходный текст |
| Ответы |
Re: Calling functions with numeric parameters
Re: Calling functions with numeric parameters |
| Список | pgsql-jdbc |
Hi All,
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.
Tim
В списке pgsql-jdbc по дате отправления: