Thusitha Kodikara написа: > Hello, > > I am interested in developing some triggers to keep track of records that are > changed (possibly the changes of one or more specific columns). In addition > to keeping the new values, I also need to keep the old values (may be on a > separate table). > > Though I have done similar things in other RDBMs using SQL, I find doing > this in Postgres, a little bit complicated - may be because it needs to be > done through a separate procedural language and through a separate function. > The Postgres documentation also didn't provide much help ( the examples in > C). I was mainly looking for example showing how to refer 'OLD' and 'NEW' > rows using PL/pgSQL. > > Can someone please direct me to some such examples?
http://www.postgresql.org/docs/8.1/static/plpgsql-trigger.html -- Milen A. Radev ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
