Home > mailing lists

Re: jsonb_array_elements_recursive() - Mailing list pgsql-hackers

From	Joel Jacobson
Subject	Re: jsonb_array_elements_recursive()
Date	February 7, 2021 20:43:29
Msg-id	04470faf-87cf-4ee5-8a9c-cbbf10624929@www.fastmail.com Whole thread Raw
In response to	Re: jsonb_array_elements_recursive() ("Joel Jacobson" <joel@compiler.org>)
List	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);

From: "Joel Jacobson"
Date: 07 February 2021, 20:42:33
Subject: Re: jsonb_array_elements_recursive()

From: Tom Lane
Date: 07 February 2021, 20:44:31
Subject: Re: Bug in query rewriter - hasModifyingCTE not getting set