That's it!!!
Thanks a lot!
Moritz
PS: Hope some day I'll be the one to be an help for newbies! I'm working on it!
2005/8/20, Tom Lane <[EMAIL PROTECTED]>:
Moritz Bayer <[EMAIL PROTECTED]> writes:
> ERROR: function public.fc_editlanguage(integer, "unknown", "unknown",> integer) does not exist
Thanks for your reply,
but your tip didn't solve my problem. I used your function call:
select fc_editlanguage(0, 'German'::varchar, 'de'::varchar, 1);
but still got an error:
ERROR: function fc_editlanguage(integer, character varying, character varying, integer) does not existHINT: No fun
Moritz,
The issue is most likely with the passed parameters themselves, not the
assignments within the function. When you call the function, be sure to
cast arguments that don't comply with your function definition. For
example:
Look at your function call. Does it look like this?
select fc_ed
Moritz Bayer <[EMAIL PROTECTED]> writes:
> ERROR: function public.fc_editlanguage(integer, "unknown", "unknown",
> integer) does not exist
>
> CREATE OR REPLACE FUNCTION "public"."fc_editlanguage" (id bigint, name
> varchar, kuerzel varchar, active smallint) RETURNS smallint AS
The short answer
Hello,
I'm a newbie to postgres and trying to produce my first functions. Everything works fine as long as it takes numeric parameters, but when I'm trying to use varchar or text-parameters, it fails and throws the following exception:
ERROR: function public.fc_editlanguage(integer, "unknown"