-- Fail when ISOK_RESULTS.First_Seen is after Last_Seen
UPDATE isok_results
  SET first_seen = last_seen + '1 day'::interval
  WHERE iqname = 'query1';
ERROR:  new row for relation "isok_results" violates check constraint "Last_Seen must be >= First_Seen"
DETAIL:  Failing row contains (1, query1, Tue Jan 02 00:00:00 1900, Mon Jan 01 00:00:00 1900, somerole, {schema1,schema2}, null, null, rtype1, null, testresult1, Informative message, null, ).