Sorry, I told you that the status was always populated but not, I need that
filter for the index because not all records are using that json structure.
When json is not null then yes, Status is always there.
I have maybe 20 or 25% of records having json populated, so, I really need
that filter.
Yes, that solution is fine. Selectivity is fine, speed is fine and the index
is "almost dynamic"
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html