Postgresql – Postgres SCD Type 1 program updating all rows instead of matching rows, unmatched rows will be updated as NULL
Postgres SCD Type 1 program updating all rows instead of only to those matching rows, those unmatched row will be updated as blank. -- Create table tableToBeUpdated CREATE TABLE "TEST"."TABLETOBEUPDATED" ( "Z" character varying(5), "ID" integer, "Y" integer ); --…