How can I search object values inside an array with Postgres jsonb?
|Added at||2016-11-20 17:11|
I'm using PostgreSQL 9.5 and the JSONB data type to store documents. My table something like this:
My documents contain an array of objects, for example:
The problem is that I would like to be able to filter on the
I've read a lot about indexes and expressions and stuff but I just can't seem to get it to work. Shouldn't this be possible?