Guest User

Untitled

a guest
Dec 13th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. SELECT changes, stmt_date::date FROM pgmemento.table_event_log el
  2. JOIN pgmemento.row_log r ON (r.event_id=el.id)
  3. JOIN pgmemento.transaction_log t on (el.transaction_id=t.txid)
  4. WHERE r.changes ?& (SELECT array_agg(key)
  5. FROM pgmemento.row_log,
  6. LATERAL jsonb_each_text(changes)
  7. WHERE key like '%_stat'
  8. GROUP BY key)
  9. ORDER BY stmt_date::date
  10.  
  11. changes, stmt_date
  12. {"X_stat": "INCOMING"}, 2017-12-13
  13. {"W_stat": "CREATED"}, 2017-12-13
Add Comment
Please, Sign In to add comment