Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group