Re: triggers problems whit function

Поиск
Список
Период
Сортировка
От Fernando Moreno
Тема Re: triggers problems whit function
Дата
Msg-id b1c45530810221359x2ef7887do6dd12b3719f0acb3@mail.gmail.com
обсуждение исходный текст
Ответ на triggers problems whit function  (Ma. Cristina Peña C. <mpena@sensacd.com.mx>)
Ответы Re: triggers problems whit function
Список pgsql-general
Дерево обсуждения
2008/10/22 Ma. Cristina Peña C. <mpena@sensacd.com.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 and 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.

Cheers.

В списке pgsql-general по дате отправления: