79643661

Date: 2025-05-29 09:39:40
Score: 2
Natty:
Report link

My colleague gave me the answer

    FROM tab t, UNPIVOT t.roles AS has_role AT role
    WHERE role like 'foo%' AND has_role = true
Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: GC30