79090611

Date: 2024-10-15 15:20:00
Score: 1
Natty:
Report link

indeed i already found the answer:

SELECT elem
FROM jsonb_array_elements('["*", "12/05/2020"]'::jsonb) AS elem
WHERE elem::text != '"*"';

you need both single and double quotes!

Reasons:
  • Low length (1):
  • Has code block (-0.5):
  • Self-answer (0.5):
Posted by: Rudi