On 4/4/23 02:01, Erik Wienhold wrote:
On 04/04/2023 03:50 CEST jian he wrote:
"Returns true if any JSON value at the given path matches the predicate.
Returns NULL when not a path predicate or comparing different types."
in first sentence, should we add something "otherwise return false."
> On 04/04/2023 03:50 CEST jian he wrote:
>
> > "Returns true if any JSON value at the given path matches the predicate.
> > Returns NULL when not a path predicate or comparing different types."
>
> in first sentence, should we add something "otherwise return false." ?
I omitted the "otherwise
On Tue, Apr 4, 2023 at 12:22 AM Erik Wienhold wrote:
> > On 03/04/2023 17:36 CEST Adrian Klaver
> wrote:
> >
> > On 4/3/23 08:11, Erik Wienhold wrote:
> > >> On 02/04/2023 17:40 CEST Adrian Klaver
> wrote:
> > >>
> > >> That is a long way from:
> > >>
> > >> jsonb @@ jsonpath → boolean
> > >>
On 4/3/23 12:00, Erik Wienhold wrote:
On 03/04/2023 18:37 CEST Adrian Klaver wrote:
On 4/3/23 09:21, Erik Wienhold wrote:
On 03/04/2023 17:36 CEST Adrian Klaver wrote:
On 4/3/23 08:11, Erik Wienhold wrote:
On 02/04/2023 17:40 CEST Adrian Klaver wrote:
That is a long way from:
jsonb @@
> On 03/04/2023 18:37 CEST Adrian Klaver wrote:
>
> On 4/3/23 09:21, Erik Wienhold wrote:
> >> On 03/04/2023 17:36 CEST Adrian Klaver wrote:
> >>
> >> On 4/3/23 08:11, Erik Wienhold wrote:
> On 02/04/2023 17:40 CEST Adrian Klaver wrote:
>
> That is a long way from:
>
>
On 4/3/23 09:21, Erik Wienhold wrote:
On 03/04/2023 17:36 CEST Adrian Klaver wrote:
On 4/3/23 08:11, Erik Wienhold wrote:
On 02/04/2023 17:40 CEST Adrian Klaver wrote:
That is a long way from:
jsonb @@ jsonpath → boolean
Returns the result of a JSON path predicate check for the specified
> On 03/04/2023 17:36 CEST Adrian Klaver wrote:
>
> On 4/3/23 08:11, Erik Wienhold wrote:
> >> On 02/04/2023 17:40 CEST Adrian Klaver wrote:
> >>
> >> That is a long way from:
> >>
> >> jsonb @@ jsonpath → boolean
> >>
> >> Returns the result of a JSON path predicate check for the specified JSON
On 4/3/23 08:11, Erik Wienhold wrote:
On 02/04/2023 17:40 CEST Adrian Klaver wrote:
That is a long way from:
jsonb @@ jsonpath → boolean
Returns the result of a JSON path predicate check for the specified JSON
value. Only the first item of the result is taken into account. If the
result is
Erik Wienhold writes:
> What do you mean? I responded to the OP's question. It's not a suggestion
> to update the docs. Obviously it's quite a mouthful and needs to be boiled
> down for the docs. Any suggestions?
At least for the example at hand, I think a good part of the confusion
stems
> On 02/04/2023 17:40 CEST Adrian Klaver wrote:
>
> That is a long way from:
>
> jsonb @@ jsonpath → boolean
>
> Returns the result of a JSON path predicate check for the specified JSON
> value. Only the first item of the result is taken into account. If the
> result is not Boolean, then NULL is
On 4/2/23 06:21, Erik Wienhold wrote:
On 01/04/2023 08:02 CEST jian he wrote:
Hi,
https://www.postgresql.org/docs/current/functions-json.html
jsonb @@ jsonpath → boolean
Returns the result of a JSON path predicate check for the specified JSON
value. Only the first item of the result is taken
Erik Wienhold writes:
> The result is true if any array element matches the predicate because
> predicates
> are evaluated on sequences. The documentation for executePredicate in
> src/backend/utils/adt/jsonpath_exec.c explains it:
I think the OP is correct that this is undocumented at the
> On 01/04/2023 08:02 CEST jian he wrote:
>
> Hi,
> https://www.postgresql.org/docs/current/functions-json.html
> > jsonb @@ jsonpath → boolean
> > Returns the result of a JSON path predicate check for the specified JSON
> > value. Only the first item of the result is taken into account. If the
>
Hi,
https://www.postgresql.org/docs/current/functions-json.html
> jsonb @@ jsonpath → boolean
>
> Returns the result of a JSON path predicate check for the specified JSON
> value. Only the first item of the result is taken into account. If the
> result is not Boolean, then NULL is returned.
>
>
14 matches
Mail list logo