Re: -- insert instead of an update

On Mon, 1 Dec 2003 10:48:15 +0100, "Alkos" <azerty_at_nospam.org> wrote:
>Logical view behaves simply as we expect (delete deletes record, update
>updates and insert inserts)
>the underlying table behaves another way (delete marks a record as deleted,
>update updates but insert the old version into a new row)
>
>My goal is to keep many versions of reference data in my database so I'm
>testing different solutions (triggers was one, I keep on searching ;-).
>Needless to say that I give up the "instead of triggers" solution :))

Why not insert the old version into a different table, and do your queries against a view that does a UNION between the "current" and "old" tables?

John

--
Photo gallery: http://www.pbase.com/john_russell/