From: Keith Carr <klinux@carrhome.eclipse.co.uk>
To: pgsql-sql@postgresql.org
Subject: Re: Temporal databases
Date: Fri, 9 Nov 2007 14:01:02 +0000
Message-ID: <200711091401.02139.klinux@carrhome.eclipse.co.uk> (raw)
In-Reply-To: <6C0CF58A187DA5479245E0830AF84F42337E29@poweredge.attiksystem.ch>
References: <6C0CF58A187DA5479245E0830AF84F42337E29@poweredge.attiksystem.ch>
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.
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:
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!!
Keith
On Wednesday 07 November 2007 13:22, Philippe Lang wrote:
> Hi,
>
> Does anyone have experience, tips, links, regarding how to build
> temporal databases with Postgresql?
>
> Thanks
>
> Philippe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: klinux@carrhome.eclipse.co.uk
Subject: Re: Temporal databases
In-Reply-To: <200711091401.02139.klinux@carrhome.eclipse.co.uk>
* 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