"Rob Johnston" <rob(at)aqq(dot)com(dot)au> writes:
> org.postgresql.util.PSQLException: ERROR: function =
> update_payable_account(integer, character varying, character varying, =
> character varying, integer, numeric, integer) does not exist
> Our function looks like this:
> CREATE OR REPLACE FUNCTION update_payable_account(id int4, name =
> "varchar", sup bpchar, cus bpchar, terms int2, del "numeric", astat =
> int4)
int2 is not integer, and bpchar is not varchar. There is an implicit
cast from varchar to bpchar, but not from int4 to int2.
regards, tom lane