Hello there,
I am working with some JSON data and want to apply a simple contains search on some data that looks like this: {green,yellow,red,cat,dog,birds}
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?