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??

 

 

 

Ing. María Cristina Peña C.

Analista Programador

 

Sensa Control Digital S.A. de C.V.

Dir. Av. Bravo #93 Ote.

Col. Centro.
Torreón Coah.

 

Tel. Directo:  (871) 747 01 04

Conmutador: (871) 747 01 01 

Tel. Fax:        (871) 747 01 90 

Correo Electrónico: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

 

<<image001.jpg>>

Reply via email to