I'm needing to update rows in one table based on updates to another. the obvious solution is a simple sql update fired by trigger.
My reading of the postgresql docs suggests that sql function is not supported by triggers?
what would be the second best approach? any samples/examples anywhere?
Thanks & regards, Mike.