When I try this function:
CREATE FUNCTION pgtest(INT4, INT4, INT4, INT4, INT8, INT4, INT2,
INT8, VARCHAR(100), VARCHAR(100), INT4, CHAR(40), INT4)
RETURNS INT4
AS '
DECLARE result INT4;
BEGIN
result := $1 + 12;
RETURN result;
END;
' LANGUAGE 'plpgsql';
it always returns NULL. If I have less arguments in there (like just
one argument) it works. I know that there is a compiled-in limit of
16 args, but this is less than 16 args, and I recompiled postgres to
take up to 30 args anyway. Any idea what's going on? Is there some
limit as to the amount of bytes a function can have as arguments?
I'm very perplexed.
Thanks