Re: [SQL] Temporal databases

2007-11-14 Thread Philippe Lang
Keith Carr wrote: > On Monday 12 November 2007 09:07, you wrote: > > Hi Philippe, > I do not know of any "extension" or "plugin" that can be used to give > database engines "temporality". Temporality will always be a tricky > subject and it would be impossible to code something general that > woul

Re: [SQL] Temporal databases

2007-11-12 Thread Philippe Lang
[EMAIL PROTECTED] 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. > However temporal tables (when done properly) are a very complex > subject at

Re: [SQL] Temporal databases

2007-11-09 Thread Keith Carr
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

[SQL] Temporal databases

2007-11-07 Thread Philippe Lang
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 y