Re: rules over multiple tables

From: Daniel Grob <dgrob(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: rules over multiple tables
Date: 2002-03-25 15:05:49
Message-ID: 19507.1017068749@www61.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Browse pgsql-novice by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2002-03-25 15:14:56 Re: rules over multiple tables
Previous Message Oliver Elphick 2002-03-25 09:43:12 Re: Can I see a content of function