Stuart Woodward <woodward(at)garage(dot)co(dot)jp> writes:
> java.sql.SQLException: ERROR: Function calcprice(numeric, integer, numeric) does not exist
> CREATE FUNCTION calcprice (float8, smallint, float8)
There's no implicit coercion from integer to smallint in 7.3. I'd
suggest changing the function's declared argument type to integer.
regards, tom lane