Martijn van Oosterhout <kleptog@svana.org> writes:
> Here's the function definition:
>> CREATE OR REPLACE FUNCTION "public"."sp_insert_users_new" (varchar, varch=
> ar,
>> varchar, varchar, smallint, date, smallint, smallint, varchar, varchar,
>> varchar, varchar, varchar, varchar, varchar) RETURNS integer AS
> As here's your error message:
>> ERROR: function public.sp_insert_users_new("unknown", "unknown", "unknow=
> n",
>> "unknown", "unknown", "unknown", integer, "unknown", "unknown", "unknown",
>> "unknown", "unknown", "unknown", "unknown", "unknown") does not exist
> It's looking for a function which accepts and integer in the 7th column
> you havn't define one. Check your function call...
The function call probably looks like ..., 42, ... and since integer
doesn't implicitly cast to smallint, it doesn't match. It would be
smarter to declare the function as taking integer; if you really want
it to take smallint, you'll need to quote or cast the arguments.
regards, tom lane