I want to change a field of a record after the modification of another field of the same record or during an insert of a new record.
Suppose the following table
field | type ---------------------------------- id | serial sign | integer value | integer real_value | integer
When inserting a new record, giving values to sign and value, the field real_value should be the product of the fields sign and value.
When updating an existing record, the value of the field real_value should be recalculated.
I tried with plpgsql functions and triggers but with no success. It works only when inserting new records and not when updating a field.
What is the best way to solve this problem ?
Kind regards
Patrick Meylemans
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
