-- validtime modications article
-- proposed SQL3

-- Populate Restricted

DROP TABLE LOT

CREATE TABLE LOT(
   LOT_ID_NUM INT,
   GNDR_CODE CHAR(1)
) AS VALIDTIME PERIOD(DATE)

VALIDTIME PERIOD '[1998-01-01 - 1998-03-23)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (101, 'c')

VALIDTIME PERIOD '[1998-03-23 - 9999-12-31)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (101, 's')

VALIDTIME PERIOD '[1998-02-17 - 9999-12-31)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-03-12 - 9999-12-31)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (799, 'c')

SELECT * FROM LOT