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