-- выбрать все связки  из "unnest(ARRAY) from Ruby",
-- которых нету в `instagram.accounts_followers`
-- не выбирает
SELECT
  account_uid,
  follower_uid
FROM (SELECT
        '999'                           AS account_uid,
        unnest(ARRAY ['6457912485849']) AS follower_uid
     ) AS af
WHERE NOT EXISTS(SELECT
                   account_uid,
                   follower_uid
                 FROM instagram.accounts_followers AS accounts_followers
                 WHERE accounts_followers.account_uid = '999');
-- af.account_uid::text

----------------------------------------------------------------------------------






















































-- выбрать всех пользователей из "unnest(ARRAY) from Ruby",
-- которых нету в таблице `instagram.accounts`

SELECT
  uid,
  nickname,
  full_name,
  status
FROM (
       SELECT
         unnest(ARRAY ['12', '999'])  AS uid,
         unnest(ARRAY ['aaa', 'bbb']) AS nickname,
         unnest(ARRAY ['A', 'B'])     AS full_name,
         'active'                     AS status) AS uids
WHERE NOT EXISTS(SELECT 1
                 FROM instagram.accounts AS accounts
                 WHERE accounts.uid = uids.uid);