Contents
List all transactions that had an effect on a certain column of a given row (audit_id) by using the ? operator:
sql
SELECT DISTINCT
e.transaction_id
FROM
pgmemento.table_event_log e
JOIN
pgmemento.row_log r
ON r.event_key = e.event_key
WHERE
r.audit_id = 4
AND (r.old_data ? 'column_B'
OR r.new_data ? 'column_B');