do you have any further examples on creation of trigger?
It is possible to have a AFTER UPDATE trigger with access to the 'deleted' & 'inserted' (before/after values) table like in sql server?
Our goal is to update the position numbering on reposition of an entity automatically within the database.
Triggers (only supported as CLR triggers) should have access to the Deleted and Inserted virtual tables much as with triggers in SQL Server. However, CLR trigger procs might have to access the tables via the DDA API rather than via SQL queries. It might also be possible to get a context SQL connection and use SQL queries, but I'm less sure of that.