Timestamp field

Started by Byron Nikolaidisover 27 years ago2 messages
#1Byron Nikolaidis
byronn@insightdist.com

Am I right in my thinking that Postgres does not have a pseudo timestamp
field that is updated whenever a row is added or updated? Did it used
to have one before time travel was removed?

If no timestamp field, are there any other pseudo fields that are
updated every time? I noticed that the 'ctid' field seems to qualify,
but what does something like (1,54) mean?

Thanks for any help.

Byron

#2Jose' Soares Da Silva
sferac@bo.nettuno.it
In reply to: Byron Nikolaidis (#1)
Re: [HACKERS] Timestamp field

On Wed, 10 Jun 1998, Byron Nikolaidis wrote:

Am I right in my thinking that Postgres does not have a pseudo timestamp
field that is updated whenever a row is added or updated? Did it used
to have one before time travel was removed?

If no timestamp field, are there any other pseudo fields that are
updated every time? I noticed that the 'ctid' field seems to qualify,
but what does something like (1,54) mean?

Thanks for any help.

Byron

Seems that XMIN field is updated whenever a row is inserted or updated.
see man sql.
Jose'