--- Michael Glaesemann <[EMAIL PROTECTED]> wrote:
> It'd be helpful if you provided links to what you refer to as the
> Current style. The only reference for managing temporal data in ANSI
> SQL I'm aware of is Snodgrass' "Developing Time-Oriented Database
> Applications in SQL"[1]. Date, Da
On May 7, 2007, at 9:59 , Richard Broersma Jr wrote:
However, since temporal UPDATEs and DELETEs do not behave in the
same way as they do in
non-temporal tables, is anyone able to successfully use Referential
Integrity constraints between
Parent and Child tables? Or are custom triggers the
In non-temporal tables, changes to the primary key of a Parent table and record
deletions can be
cascaded to a related Child table using "REFERENCES Parent( Parent_code ) ON
DELETE CASCADE ON
UPDATE CASCADE,"
However, since temporal UPDATEs and DELETEs do not behave in the same way as
they do i
