Hi all,
I've now updated to Postgres 7.2 and increased the max. Arguments to 70.
With the same syntax I used before (and get the Error that there are too
many arguments) I now get another Error:
ERROR: there is no built-in function named "
declare
"ID_ADDR" alias for $1;
...
return 1;
END;"
See below the Syntax I used:
create function
delete_irgendwas_function (int4,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" AND .... "SIGN" =
f_"SIGN";
return 1;
END;'
LANGUAGE 'internal';
Has anyone an idea what I maybe have do wrong?
Thanks for help.
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net