How to update table records by pairs old value -> new value?

Question

PostgreSQL

There is a table and a dozen records:

CREATE TABLE test
(
  id serial,
  target_id integer
);
INSERT INTO test (1, 1206);
INSERT INTO test (1, 1210);
INSERT INTO test (1, 1211);
INSERT INTO test (1, 1250);

and I have pairs of values ​​"on hand" (let it be an array):
1206=>1281,
1210=>1282,
1211=>1283,
1250=>1287

can I somehow replace 1206 in the table with 1281 and further down the list a simple or complex query without running as many queries as there are pairs of values?

Answer 1

UPDATE test SET
  target_id = t.new_id
FROM (
  SELECT
    unnest(ARRAY[1206, 1210, 1211, 1250]) AS old_id,
    unnest(ARRAY[1281, 1282, 1283, 1287]) AS new_id
) AS t
WHERE target_id = t.old_id