Thread

1. Timestamp field

   Byron Nikolaidis <byronn@insightdist.com> — 1998-06-10T17:19:23Z

   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
   
   
   

2. Re: [HACKERS] Timestamp field

   jose' soares <sferac@bo.nettuno.it> — 1998-06-11T10:56:07Z

   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'