Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 5A7B237C6CB
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 12 Nov 2007 05:08:14 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 53756-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 12 Nov 2007 05:07:55 -0400 (AST)
Received: from mail.attiksystem.ch (f29.attiksystem.ch [212.147.59.29])
	by postgresql.org (Postfix) with ESMTP id 3E3FB37B9B0
	for <pgsql-sql@postgresql.org>; Mon, 12 Nov 2007 05:07:57 -0400 (AST)
Received: from poweredge.attiksystem.ch (poweredge.attiksystem.ch [10.0.0.29])
	by mail.attiksystem.ch (8.12.11/8.12.11) with ESMTP id
	lAC97ptu000479; Mon, 12 Nov 2007 10:07:51 +0100 (CET)
	(envelope-from philippe.lang@attiksystem.ch)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Temporal databases
Date: Mon, 12 Nov 2007 10:07:51 +0100
X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12
Message-ID: <6C0CF58A187DA5479245E0830AF84F4218CF70@poweredge.attiksystem.ch>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [SQL] Temporal databases
thread-index: Acgi2MvUcE76JlymSP+kKDp/QmAszgCMTfyg
References: <6C0CF58A187DA5479245E0830AF84F42337E29@poweredge.attiksystem.ch>
	<200711091401.02139.klinux@carrhome.eclipse.co.uk>
From: "Philippe Lang" <philippe.lang@attiksystem.ch>
To: "Keith Carr" <klinux@carrhome.eclipse.co.uk>, <pgsql-sql@postgresql.org>
X-Scanned-By: MIMEDefang 2.49 on 10.0.0.111
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/45
X-Sequence-Number: 29573

pgsql-sql-owner@postgresql.org wrote:
> Hi Philippe,
> Have a look at the post I made to the pgsql-sql list I made on 6th
> November 2007 (day before you posted this). It contains alot of stuff
> for temporal tables within Postgres.=20
> However temporal tables (when done properly) are a very complex
> subject at the best of times. It depends how much you want to
> integrate them. A good place to start is Joe Celko's book "SQL For
> Smarties" and Richard Snodgrass' book "Developing Time-Oriented
> Database Applications in SQL" - this book is no longer in print, but
> is downloadable (for FREE!) from:   =20
> http://www.cs.arizona.edu/~rts/tdbbook.pdf
> Richard Snodgrass is one of the leading experts in the field. I warn
> you - the book is heavy going - but so worth it!!=20
>=20
> Keith

Hi Keith,

I saw your post a few minutes after I posted mine, but I wasn't aware of
the free book of Richard Snodgrass. Thanks for the link!

Have you ever heard about some sort of database extension, or plugin,
that allows using databases "temporally" without have to explicitely add
code in into the schema?

Is there an SQL standard already defined for querying databases
temporally? I think I read about a "Time Connector" or something similar
for Oracle, a few years ago...

Regards,

Philippe Lang