On Thursday, January 6, 2022, Andreas Joseph Krogh <
andreas@visena.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.