Contents

List all rows that once had a certain value by using the @> operator:

sql SELECT DISTINCT audit_id FROM pgmemento.row_log WHERE old_data @> '{"column_B": "old_value"}'::jsonb;