Re: 'last updated' or 'last added'

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Marc Cuypers <mozilla(at)mgvd(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 'last updated' or 'last added'
Date: 2003-07-23 10:47:29
Message-ID: Pine.LNX.4.56.0307231244490.1649@krusty.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marc Cuypers writes:

> Is there a way to know which record in a query was last updated or last
> inserted?

Not really, you will need to write a trigger to keep track of that
information in an additional column in the table (or somewhere else).

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jochem van Dieten 2003-07-23 12:21:48 Re: 0/1 vs true/false
Previous Message Shridhar Daithankar 2003-07-23 09:54:01 Re: Performance hit of foreign key constraints?