absolute or relative updates

From: "pgsql-general(at)list(dot)coretech(dot)ro" <pgsql-general(at)list(dot)coretech(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: absolute or relative updates
Date: 2005-11-16 16:52:25
Message-ID: 437B63C9.4090801@list.coretech.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I want to write a trigger that logs any changes that are made to a row.
I have the old an new row values, but I am more interested in knowing if
the update was absolute "UPDATE table SET col = 3" or relative "UPDATE
table SET col = col + 2".
Is the a way (any way) to access this type of information ? In any
language available (C, PLPGSQL, etc.)

Thanks
Razvan Radu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-11-16 16:55:20 Re: PREPARE TRANSACTION and webapps
Previous Message john.bender 2005-11-16 16:40:03 Rebranding PostgreSQL