Re: 'last updated' or 'last added' - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: 'last updated' or 'last added'
Date
Msg-id Pine.LNX.4.56.0307231244490.1649@krusty.credativ.de
Whole thread Raw
In response to 'last updated' or 'last added'  (Marc Cuypers <mozilla@mgvd.be>)
List 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@gmx.net

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Performance hit of foreign key constraints?
Next
From: Jochem van Dieten
Date:
Subject: Re: 0/1 vs true/false