Hi,
On 11/14/19 1:04 PM, Tom Lane wrote:
As of v12, that WITH will get flattened, so that you still end up
with three invocations of jsonb_path_query_first, as EXPLAIN VERBOSE
will show you. You could write "WITH foo AS MATERIALIZED ..." to
prevent that, but then you'll need to stick the WHERE
Jesper Pedersen writes:
> We have a table which has a jsonb column in it. Each row contains a lot
> of data in that column, so TOASTed.
> We have to extract data from that column at different levels, so an
> example query could look like
> select
>col1,
>col2,
> jsonb_path_query_first(
