Re: rule calls function, passing OLD

On Wed, 14 Jul 2004, R.Welz wrote:

> test=# \i '/home/myAccount/Documents/Datenbank Layout/Postgres
> Sytax/test/Regeln2'
> CREATE FUNCTION
> psql:/home/myAccount/Documents/Datenbank Layout/Postgres
> Sytax/test/Regeln2:16: ERROR: function
> deny_namen_telefonverweise(namen_telefonverweise) does not exist
> HINT: No function matches the given name and argument types. You may
> need to add explicit type casts.

I'd think you'd want the function declared as above (using the specific
rowtype), not as one taking record, which appears to work for me.

> CREATE OR REPLACE FUNCTION deny_namen_telefonverweise(record) RETURNS
> void AS '
> DECLARE
> result RECORD;
>
> BEGIN
> /* DELETE ROW LATER */
> SELECT 1+1;
>
> END;
> '
> LANGUAGE 'plpgsql';
>
>
> CREATE OR REPLACE RULE deny_namen_Telefonverweise AS ON DELETE TO
> Namen_Telefonverweise
> DO INSTEAD
> SELECT DENY_Namen_Telefonverweise(OLD);