On Nov 24, 2022, at 12:44, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> JSONPath can do/represent much more than you are thinking here.
>
> https://www.postgresql.org/docs/current/datatype-json.html#DATATYPE-JSONPATH
>
> Note the second entry ($varname) in table 8.24
Ah, I see. SQL/JSON syntax gets a bit confusing relative to other flavors.
D