Re: PROBLEM: Function does not exist

On Thu, Jun 23, 2005 at 12:36:50AM +0200, Julian Legeny wrote:
>
> CREATE OR REPLACE FUNCTION insert_bf_filter(int4, int4, "varchar", "varchar", int4, int2, int2, int4, int2, int4)

[-snip-]

> select INTGR, TMSTP from INSERT_BF_FILTER (53, 1354, 'test_filter_name', 'test_filter_description', 1, 0, 0, 10, 0, 100)
>
> And it returns me following error:
> ERROR: function insert_bf_filter(integer, integer, "unknown", "unknown", integer, integer, integer, integer, integer, integer) does not exist
> HINT: No function matches the given name and argument types. You may need to add explicit type casts.

Follow the hint: use explicit type casts for the int2 arguments. Try this:

select INTGR, TMSTP
from INSERT_BF_FILTER(53, 1354, 'test_filter_name', 'test_filter_description',
1, 0::int2, 0::int2, 10, 0::int2, 100);

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/