Search-by-key / PostgreSQL Extension Network

Contents

List all transactions that had an effect on a certain column of a given row (audit_id) by using the ? operator:

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');