Re: Problem with self-made plpgsql-function / casting

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
> Moritz Bayer <moritz(dot)bayer(at)googlemail(dot)com> 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="http://ad.zanox.com/ppv/?2510394C569771607" align="bottom"
width="1" height="1" border="0" hspace="1"><a href="
http://ad.zanox.com/ppc/?2510394C569771607T">Lenscare AG - Europas größter
Kontaktlinsenversand</a>