Quote Originally Posted by Shadowayara View Post
...
CREATE TABLE uitgifte
(uitgiftenr SERIAL PRIMARY KEY,
klantnr INT,
datum DATE,
CONSTRAINT gt_now CHECK (datum >= now())
FOREIGN KEY (klantnr) REFERENCES klant (klantnr))

...
Try this. Note the separate table constraint.