On Wed, Oct 27, 2021 at 04:18:20PM -0700, David G. Johnston wrote:
> On Wed, Oct 27, 2021 at 11:58 AM wrote:
>
> >
> > I've found out that one can treat a string singleton as if it
> > were an array:
> >
> > foo=# select '"foo"'::jsonb ->> 0;
> >?column?
> > --
> >foo
> > (1
On Wed, Oct 27, 2021 at 11:58 AM wrote:
>
> I've found out that one can treat a string singleton as if it
> were an array:
>
> foo=# select '"foo"'::jsonb ->> 0;
>?column?
> --
>foo
> (1 row)
>
> which conveniently returns the right type. My question: can I rely
> on that, o
