Fernando Moreno a écrit : > 2008/10/22 Ma. Cristina Peña C. <mpena@xxxxxxxxxxxxxx > <mailto:mpena@xxxxxxxxxxxxxx>> > > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
