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 по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Customizing SSL with jdbc
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: Calling functions with numeric parameters