Postgresql – Collectiong Anti-Join Results via Window Function?
I have a table: CREATE TABLE t_table ( c_id int4 NOT NULL, c_date_called int4 NOT NULL, CONSTRAINT t_table_un UNIQUE (c_id, c_date_called) ); that stores distinct snapshots of data, with data as such: INSERT INTO t_table (c_id, c_date_called) VALUES (1,9), (2,9),…