From: | William Leite Araújo <william(dot)bh(at)gmail(dot)com> |
---|---|
To: | "Ottavio Campana" <ottavio(at)campana(dot)vi(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: more than 32 parameters to a function? |
Date: | 2006-10-26 17:51:36 |
Message-ID: | bc63ad820610261051j6ee2441fsa4e7bc5c73eca106@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)campana(dot)vi(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Volkan YAZICI | 2006-10-26 17:52:08 | Re: more than 32 parameters to a function? |
Previous Message | Erik Jones | 2006-10-26 17:46:37 | Re: more than 32 parameters to a function? |