Re: JSONB operator unanticipated behaviour

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Mendoza <brian(at)rotamap(dot)net>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: JSONB operator unanticipated behaviour
Date: 2023-05-18 15:46:53
Message-ID: 3802023.1684424813@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brian Mendoza <brian(at)rotamap(dot)net> writes:
> Ah, yes, that seem to be the explanation!
> So it would seem that indeed it was my misunderstanding of the operator.

You seem to be reading some fairly old version of the documentation.
The extended definition that Adrian mentions has been there for
awhile, but the JSON operator table didn't link to it before v13.
(I agree that the "top level" bit was just wrong, but it's gone.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2023-05-18 15:54:31 Re: Would PostgreSQL 16 native transparent data encryption support database level encryption?
Previous Message Brian Mendoza 2023-05-18 15:09:22 Re: JSONB operator unanticipated behaviour