postgres insert if not exists - iphone sim not supported

INSERT INTO service (name, id, active) SELECT a. if i ain t got you download name, a. maybe if bibi id, true FROM api a WHERE a name NOT IN (SELECT name FROM service) RETURNING name inserts new services from the api table into the service table and the second: UPDATE service s SET active = false WHERE s name NOT IN (SELECT name FROM api) RETURNING s name