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