rogervellacott wrote:

> I suspect this would create an endless loop.
>
> Better would be
> update test_table s
> set s.kyriga = 'test'
> where s.<primary key> = new.<primary key>
> and s.kyriga <> 'test'

If the field 'kyriga' is nullable, make sure you use:

update test_table s
set s.kyriga = 'test'
where s.<primary key> = new.<primary key>
and s.kyriga is distinct from 'test';


--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com