Strange bug in PLpgsql? - Mailing list pgsql-general

From
Subject Strange bug in PLpgsql?
Date
Msg-id 20010210214645.619.qmail@mailhost.sidereal.kz
Whole thread Raw
Responses Resolved, maybe (Re: Strange bug in PLpgsql?)
Re: Strange bug in PLpgsql?
List pgsql-general
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

pgsql-general by date:

Previous
From: GH
Date:
Subject: select...except...union, Simpler query?
Next
From: Christopher Sawtell
Date:
Subject: Re: Checking Permissions with SQL