On Thursday, January 6, 2022, Andreas Joseph Krogh <andreas(at)visena(dot)com>
wrote:
>
>
> I think you misread my message. What I want is for the subscript-version:
>
> ('{"key":"value"}'::jsonb)['key']
>
> to return:
>
> ┌──────────┐
> │ ?column? │
> ├──────────┤
> │ value │
> └──────────┘
>
> instead of
>
> ┌─────────┐
> │ jsonb │
> ├─────────┤
> │ "value" │
> └─────────
>
>
A given syntax/operator can only return one thing so what you want is
fundamentally not possible.
David J.