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'

Roger Vellacott

<aharrison@...> wrote:

> If the change must actually be done after the insert occurs,
> you could try something like this:
>
> update test_table s
> set s.kyriga = 'test'
> where s.<primary key> = new.<primary key>
>
> replacing <primary key> with the name of the primary key field.
>