On Thursday, January 6, 2022, Andreas Joseph Krogh <andreas(at)visena(dot)com>
wrote:
>
> Apparently I'm after a solution which either casts this to varchar or a
> function that takes JSONB as argument and outputs the first field-value as
> varchar.
>
>
You can try casting the value though IIRC it doesn’t actually work
(limitation of the feature). The fact is that the ‘ - - > ‘ operator gives
you the needed output.
David J.