Re: rules over multiple tables

Hi all,

I'm now upgrading to Version 7.2.

Here's already the Syntax that dosn't work:

create function
delete_irgendwas_function

(int4,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,text,text,text,text,text,text,text,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,varchar,int4,varchar,date,time,varchar,varchar,text,varchar,varchar,int4,varchar,int4,varchar,varchar,varchar,varchar,varchar,varchar,varchar,date,varchar)
returns boolean as '
declare
"ID_ADDR" alias for $1;
"COMPANY" alias for $2;
...
"SIGN" alias for $65;
begin
delete from "ADDRESSES"
where "ID_ADDR" = f_"ID_ADDR" AND "COMPANY" = f_"COMPANY" ...;
delete from "CONTACTS"
where "ID" = f_"ID" AND "C_CATEGORY" = f_"C_CATEGORY" ...;
return 1;
END;'
LANGUAGE 'internal';
ERROR:  Procedures cannot take more than 16 arguments

I tried to change MAX_ARGS in /src/include/config.h.in but it dosn't work
(compilation failed, unknown attribute).

Has anyone another Idea how to delete (and update) over two tables?

--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net