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
>
> CREATE OR REPLACE FUNCTION "public"."fc_editlanguage" (id bigint, name
> varchar, kuerzel varchar, active smallint) RETURNS smallint AS
The short answer to this is to avoid declaring function arguments as
"smallint". When you call this as, say,
select fc_editlanguage(42, 'foo', 'bar', 1);
the "42" and the "1" are initially typed as integer constants. There's
an implicit up-cast from integer to bigint, so the parser has no problem
matching the 42 to a bigint parameter, but the down-cast from integer to
smallint is not implicit. With the function as written you'd have to
cast to smallint explicitly:
select fc_editlanguage(42, 'foo', 'bar', 1::smallint);
This is enough of a notational pain in the neck that it's easier just to
declare the argument as integer.
regards, tom lane
--
<img src="" href="http://ad.zanox.com/ppv/?2510394C569771607">http://ad.zanox.com/ppv/?2510394C569771607 " align="bottom" width="1" height="1" border="0" hspace="1"><a href="" href="http://ad.zanox.com/ppc/?2510394C569771607T"">http://ad.zanox.com/ppc/?2510394C569771607T" >Lenscare AG - Europas größter Kontaktlinsenversand</a>
