Re: triggers problems whit function

El mié, 22-10-2008 a las 15:01 -0500, Ma. Cristina Peña C. escribió:
> 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??

write your function in plpgsql

http://www.postgresql.org/docs/8.3/interactive/plpgsql-trigger.html

>
>
>
>
>
> cid:image002(dot)jpg(at)01C8F24F(dot)E2D90230
>
> 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: mpena(at)sensacd(dot)com(dot)mx
>
>
>
>