PostgreSQL jsonb nested pattern matching text search across multiple rows
|Added at||2016-12-11 21:12|
as stated in the title, I am attempting to do a query that preforms a full text search on multiple rows, agains a jsonb data type, with nested data, the problem is as follows:
I would like to do a query for books, by the names of the characters within each book. For example query every book with a character named "foo". While the outline above is just an example my real life scenario calls for me to do a search on character's name using the "~*" operator.
So far im pretty stumped on this so any help would be appreciated, thanks.