-- validtime modications article
-- proposed SQL3

vtmod.populaterestricted

-- a logical current insertion

INSERT INTO LOT
VALUES (433, 'h')

SELECT * FROM LOT

-- a logical current deletion

DELETE FROM LOT
WHERE LOT_ID_NUM = 101

SELECT * FROM LOT

-- a logical current update

UPDATE LOT
SET GNDR_CODE = 's'
WHERE LOT_ID_NUM = 799

vtmod.populategeneral

-- A logical current deletion, in the general scenario 

DELETE FROM LOT
WHERE LOT_ID_NUM = 234

SELECT * FROM LOT

-- a logical current update, in the general scenario

vtmod.populategeneral

UPDATE LOT
SET GNDR_CODE = 's'
WHERE LOT_ID_NUM = 799

SELECT * FROM LOT

-- sequenced insertion

vtmod.populategeneral

VALIDTIME PERIOD '[1998-03-26 - 1998-04-14)'
INSERT INTO LOT
VALUES (426, 'h')

SELECT * FROM LOT

-- a sequenced deletion

VALIDTIME PERIOD '[1998-10-01 - 1998-10-22)'
DELETE FROM LOT
WHERE LOT_ID_NUM = 234

SELECT * FROM LOT

-- a sequenced update

vtmod.populategeneral

VALIDTIME PERIOD '[1998-03-01 - 1998-04-01)'
UPDATE LOT
SET GNDR_CODE = 's'
WHERE LOT_ID_NUM = 799

SELECT * FROM LOT

-- a nonsequenced modification

NONSEQUENCED VALIDTIME DELETE FROM LOT
WHERE LOT_ID_NUM = 234
   AND (CAST(INTERVAL(VALIDTIME(LOT)) AS INTERVAL MONTH) > INTERVAL '3' MONTH

SELECT * FROM LOT