Re: triggers problems whit function

Fernando Moreno a écrit :
> 2008/10/22 Ma. Cristina Peña C. <mpena(at)sensacd(dot)com(dot)mx
> <mailto:mpena(at)sensacd(dot)com(dot)mx>>
>
> I want to use a function in to a trigger
>
> This is my
>
> CREATE FUNCTION "subradio"(integer) RETURNS integer AS 'select
> cast(count (claveubica) as integer ) from asradios where ubicacion
> =0;' LANGUAGE 'sql';
>
> And my ttrigger is
>
> CREATE TRIGGER validaradios AFTER DELETE ON subestacion FOR EACH ROW
> EXECUTE PROCEDURE subradio(0);
>
> But I got an error
>
> ERROR: CreateTrigger: function subradio() does not exist
>
> What can I do??
>
> A trigger function must have a specific structure, it takes no arguments

It can take arguments.

> and returns "trigger".

And this is why, I think, the message tells "function subradio does not
exist". Because there's no subradio function that returns trigger.

> Besides, trigger functions are supposed to do
> some processing before or after insert, update or delete operations, so
> there's no sense in returning a row count.
>
> Take a look at the docs, specially chapter 35 and 38.9.
>

Regards.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com