Re: more than 32 parameters to a function? - Mailing list pgsql-general

From William Leite Araújo
Subject Re: more than 32 parameters to a function?
Date
Msg-id bc63ad820610261051j6ee2441fsa4e7bc5c73eca106@mail.gmail.com
Whole thread Raw
In response to more than 32 parameters to a function?  (Ottavio Campana <ottavio@campana.vi.it>)
List pgsql-general
     Create a type whith the fields?!
     Ex.:
            Create type myType as (field1 integer, field2 integer, ...);
            Create or replace function func_type(myType) returns integer AS
            $$
            DECLARE
                param ALIAS FOR $1;
            BEGIN
                RAISE LOG 'Param fields: %, %, %, ... ', param.field1, param.field2, ...;
            END;
            $$ LANGUAGE plpgsql;

 
2006/10/26, Ottavio Campana <ottavio@campana.vi.it>:
I'm writing some stored procedures in pl/pgsql for a database using
postgresql 7.4.7.

I need to write a complex function with 65 arguments, but when I try to
run it I get an error complaining that arguments can be up to 32.

Is there a way to solve this problem or do I have to try to split the
function into three new ones?

--
Non c'e' piu' forza nella normalita', c'e' solo monotonia.






--
William Leite Araújo

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: more than 32 parameters to a function?
Next
From: Volkan YAZICI
Date:
Subject: Re: more than 32 parameters to a function?