From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
Cc: | Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Extracting data from jsonb array? |
Date: | 2020-12-08 01:59:52 |
Message-ID: | CAKFQuwYQcgnEczC8j37U3UuXDmCR7+7_s=M=gs97YM=mesrd_A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Monday, December 7, 2020, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> wrote:
>
>
> I'm of course very glad Postgresql has the ability to work with JSON at
> all, but as I dig into it I'm kinda surprised at the level of complexity
> needed to extract data in relatively simple ways. Hopefully eventually it
> will seem simple to me, as it seems to appear to others.
>
Upgrade to v12+ for access to simpler/cleaner. Composing various unnesting
and key extraction operations works but, yes, it gets ugly proportional to
the extent you need to dig into complex json structures. That said lateral
joining reduces nesting which is measurably cleaner.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Baldwin | 2020-12-08 03:12:07 | Re: Extracting data from jsonb array? |
Previous Message | Ken Tanzer | 2020-12-08 01:39:59 | Re: Extracting data from jsonb array? |