table event pkey_id = serial event_id = integer event_date = date(YYYY-MM-DD) event_num = integer UPDATE event e SET event_id = 41 WHERE event_id = 37 AND NOT EXISTS ( SELECT 1 FROM event WHERE event_id = 41 AND event_date = e.event_date AND event_num = e.event_num )