На Mon, 31 Jul 2006 17:00:47 -0000
"martinknappe" <martin@...> написа:

> hi
>...
> CREATE trigger dicentries_bu0 for dicentries
> active before update position 0
> as
> declare variable wanted_id bigint;
> begin
> for select id from dicentries where asverwid = new.id
> into :wanted_id do begin
> update dicentries
> set
> asverwterm = new.asterm
> where
> ID = :wanted_id;
> end
> end
>
>
> does any of you see why it doesnt work?
>

I do not know what you have in mind with "it doesnt work", but your
trigger will fire infinite loop of BEFORE UPDATE trigger.

Cheers,
--
Miroslav Penchev