Re: jsonb_array_elements_recursive()

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: "Zhihong Yu" <zyu(at)yugabyte(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "PostgreSQL Developers" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: jsonb_array_elements_recursive()
Date: 2021-02-07 17:43:29
Message-ID: 04470faf-87cf-4ee5-8a9c-cbbf10624929@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Feb 7, 2021, at 18:42, Joel Jacobson wrote:
> SELECT pit.jsonb_array_elements_recursive(value);

Sorry, that line should have been:

SELECT unnest(value);

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-02-07 17:44:31 Re: Bug in query rewriter - hasModifyingCTE not getting set
Previous Message Joel Jacobson 2021-02-07 17:42:33 Re: jsonb_array_elements_recursive()