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