How to get last non null values and aggregated non null values by timestamp from event sourcing JSONB column in PostgreSQL?
I'm working with event sourced data where all of the important fields are combined to a JSONB column and many of the keys are missing from most of the database rows. I would want to get: Aggregated combined values of…