79343501

Date: 2025-01-09 17:26:00
Score: 1
Natty:
Report link

Following Muhammad Danial Shauket's thinking, I realized I could lower just the JSON array that I was extracting from the column, like so.

select * from events where lower("Key1:VaLuE1") member of(lower(meta->"$.tags"));

This works perfectly! Thanks to samhita for the fiddle: https://dbfiddle.uk/k8lT4DRg

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
Posted by: hackel