I would like to use the oid as a unique key for a table but in creating
a test table and playing around with inserts, things don't seem to be
working as I thought they would.
create table test (
key oid,
desc varchar(30));
Then I do an insert
insert into test (desc) values ('inf
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
