For each statement trigger and update table

--000000000000fe8752059b44661d
Content-Type: text/plain; charset="UTF-8"

Not sure if this is possible
Basically I want to have a trigger which updates an array column in the
same table when a column is updated
This works as a row level trigger, but not as per statement
I have hit the recursive issue (where update fires update trigger which
fires etc)
According to the docs I cannot use columns and relative tables together

So any suggestions? I can give code when I get home, but it's pretty simple
stuff

--000000000000fe8752059b44661d
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Not sure if this is possible<div dir=3D"auto">Basically I=
 want to have a trigger which updates an array column in the same table whe=
n a column is updated</div><div dir=3D"auto">This works as a row level trig=
ger, but not as per statement</div><div dir=3D"auto">I have hit the recursi=
ve issue (where update fires update trigger which fires etc)</div><div dir=
=3D"auto">According to the docs I cannot use columns and relative tables to=
gether</div><div dir=3D"auto"><br></div><div dir=3D"auto">So any suggestion=
s? I can give code when I get home, but it&#39;s pretty simple stuff=C2=A0<=
/div></div>

--000000000000fe8752059b44661d--