-- Fail when ISOK_RESULTS.Resolved is before First_Seen

UPDATE isok_results
  SET resolved = first_seen - '1 day'::interval
  WHERE iqname = 'query1';