On Nov 24, 2004, at 7:07 PM, Najib Abi Fadel wrote:
Is there a to get the row creation time if we know it's object ID ??
Only if you have a timestamp column on the table that records the creation time. For example,
create table foo (
foo_id serial not null unique
, created_timestamp timestamptz not null
default current_timestamp
) without oids;Some people also like to include a modified_timestamp column, which can easily be updated via an after update trigger.
hth
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
