Postgres 9.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE hasil_perhitungan
    ("id" int unique, "hasil" int)
;
    
INSERT INTO hasil_perhitungan
    ("id", "hasil")
VALUES
    (21, 666),
    (22, 777),
    (23, 777),
    (24, 777),
    (25, 777)
;


CREATE TABLE list_di
    ("id" int)
;
    
INSERT INTO list_di
    ("id")
VALUES
    (19),
    (20),
    (21)
;
5 rows affected

3 rows affected

CREATE OR REPLACE FUNCTION coba(input_data integer)
  RETURNS void AS
  $BODY$
BEGIN
    INSERT INTO hasil_perhitungan 
    SELECT id , 999 FROM list_di ON CONFLICT (id)
       DO UPDATE SET hasil = 888;
END;
$BODY$
LANGUAGE plpgsql;
SELECT coba(25);


coba





select * from hasil_perhitungan;


id
hasil


22
777

23
777

24
777

25
777

19
999

20
999

21
888