SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE facts1 ( "the_date" date, "title" varchar(255) ); CREATE TABLE facts2 ( "the_date" date, "title" varchar(255) ); INSERT INTO facts1 ("the_date", "title") VALUES ('01.03.2022', 'Title1'), ('02.03.2022', 'Title2'), ('02.03.2022', 'Title3'), ('03.03.2022', 'Title4'); INSERT INTO facts2 ("the_date", "title") VALUES ('01.03.2022', 'Title2'), ('01.03.2022', 'Title3'), ('03.03.2022', 'Title4'); CREATE OR REPLACE PROCEDURE proc(IN the_date date DEFAULT (CURRENT_DATE - 1)) LANGUAGE sql AS $$ MERGE INTO facts1 f1 USING facts1 f2 ON f1.date = f2.date WHEN MATCHED THEN DO NOTHING WHEN NOT MATCHED THEN INSERT INTO facts1 SELECT * FROM facts2 ; $$;