From: Michael J Schout <mschout@gkg.net>
To: Johann Spies <jhspies@alpha.futurenet.co.za>
Cc: Postgres-poslys <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] The date of an entry?
Date: Sat, 11 Jul 1998 16:15:43 +0000
Message-ID: <35A78FAF.8D6E54AF@gkg.net> (raw)
References: <Pine.LNX.3.95.980710092726.490B-100000@Johann>
Johann Spies wrote:
>
> Is there a system field that can enable me to determine when an entry into
> the database was made? I see a reference to 'abstime'. How can that be
> accessed?
Abstime is a column type, just like datetime, date, or even int for that
matter. Once upon a time, there used to be "time travel" in postgreSQL
so every row had a tmin,tmax field in it that would show the last time
the row was updated, but they are no longer available as time travel
was removed in the interest of efficiency. You can get the same effect
by creating your own timestamp column though:
create table foo (ts timestamp default now(), f1 int);
insert into foo (f1) values (12345);
select * from foo;
ts | f1
----------------------+-----
1998-07-11 11:10:37-05|12345
(1 row)
Regards,
Mike
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: mschout@gkg.net, jhspies@alpha.futurenet.co.za
Subject: Re: [SQL] The date of an entry?
In-Reply-To: <35A78FAF.8D6E54AF@gkg.net>
References: <Pine.LNX.3.95.980710092726.490B-100000@Johann> <35A78FAF.8D6E54AF@gkg.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox