Dear,
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
