Re: [SQL] Problem with self-made plpgsql-function / casting

2005-08-20 Thread Moritz Bayer
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

Re: [SQL] Problem with self-made plpgsql-function / casting

2005-08-20 Thread Moritz Bayer
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

Re: [SQL] Problem with self-made plpgsql-function / casting

2005-08-20 Thread Mark Dingee
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

Re: [SQL] Problem with self-made plpgsql-function / casting

2005-08-20 Thread Tom Lane
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

[SQL] Problem with self-made plpgsql-function / casting

2005-08-20 Thread Moritz Bayer
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"