What is the correct way to create a table column that timestamps itself
whenever an insert OR update occurs.
Here is my guess
create table (
x int2
modtime timestamp current()
);
but from reading the docs on the website, it seems that current() gives
you a timestamp when the information is read, rather than updated.
Also will this do the same thing as
timestamp default now()
to timestamp inserted rows?
Or, am I going about this in the wrong way and there is something like
an oid, hidden, that contains this information already?
Thanks
Chris
