79085606

Date: 2024-10-14 09:47:08
Score: 0.5
Natty:
Report link

Yes, @Bergi, you're right.
I eventually succeeded.

WITH requisites AS (
   SELECT attributes->'rule'->'requisite' AS requisite
      FROM mytable
)
select jsonb_array_elements(requisite)->'link'->'object' from requisites
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • User mentioned (1): @Bergi
  • Self-answer (0.5):
  • High reputation (-1):
Posted by: Marc Le Bihan