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: (view raw, whole thread or download thread mbox)
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 "
"ID_ADDR" alias for $1;
return 1;

See below the Syntax I used:

create function
delete_irgendwas_function (int4,varchar,...)
returns boolean as '
"ID_ADDR" alias for $1;
"COMPANY" alias for $2;
"SIGN" alias for $65;
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" =
return 1;
LANGUAGE 'internal';

Has anyone an idea what I maybe have do wrong?

Thanks for help.


GMX - Die Kommunikationsplattform im Internet.

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-2017 The PostgreSQL Global Development Group