I am working with some JSON data and want to apply a simple
contains search on some data that looks like this:
I just want all the columns that contain
green. However, when I try to do a
contains search, metabase gives me this error:
ERROR: function lower(character varying) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 1507
How do I add these explicit type casts? What is going on here?