Re: i want to find

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: chamil wijenayake <chamil82(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: i want to find
Date: 2005-03-27 07:09:58
Message-ID: 20050327070958.GA46060@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

[Reply-To set to pgsql-general]

On Fri, Mar 25, 2005 at 11:11:19PM -0800, chamil wijenayake wrote:

> i want to find the last update time of a tuple(row) in the postgresql data base

You can set up a trigger to maintain a timestamp for the row. See
the example in the "Trigger Procedures" section of the PL/pgSQL
documentation.

http://www.postgresql.org/docs/8.0/interactive/plpgsql-trigger.html

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Karel Zak 2005-03-27 10:03:52 Re: Bug 1500
Previous Message Tom Lane 2005-03-27 07:09:28 Re: problem with rules - column values lost