-- Succeed when ISOK_RESULTS.Resolved is equal to First_Seen UPDATE isok_results SET resolved = first_seen + '1 day'::interval WHERE iqname = 'query1';