I am querying a database and trying to search for words that are contained within strings in a column. In my query if I attempt to filter by a column that “contains” any word or value I get the same returned error.
ERROR: operator does not exist: jsonb ~~ character varying Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
In my data model I have attempted to change value types to accommodate this without any luck.
Any suggestions as to where I am failing?