Re: Invoke diff from plpgsql?

George Pavlov <gpavlov@mynewplace.com> wrote:

> Wondering how to invoke a application like diff from plpgsql? Thanks!

And don't forget that you are working with a database. Most diff-ing
uses can probably be handled by constructs like EXCEPT and INTERSECT to
say nothing of OUTER JOINs. Also, IS DISTINCT FROM is your friend if you
want a comparison that treats NULLs as "normal" data values.

Thanks for the replies. What I wanted to do was just track the changes to a column... like svn does so I can get a history and incremental changes of a article per user handled by a trigger. Saving the output from diff seemed simple enough rather than the entire article.

Is there a contrib modules or otherwise to enable tracking changes like that in plpgsql?

---

Feel free to call! Free PC-to-PC calls. Low rates on PC-to-Phone. Get Yahoo! Messenger with Voice