'last updated' or 'last added'

Started by Marc Cuypersover 22 years ago2 messagesgeneral
Jump to latest
#1Marc Cuypers
mozilla@mgvd.be

Hi,

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

--
Best regards,

Marc.

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Marc Cuypers (#1)
Re: 'last updated' or 'last added'

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