Unexpected zero results - Mailing list pgsql-general

From Viliam Ďurina
Subject Unexpected zero results
Date
Msg-id CAO=iB8K_AJe-x7gZSCS+ndTAsE2XUj8+i7rP5UHxvUO6cMySBw@mail.gmail.com
Whole thread Raw
Responses Re: Unexpected zero results
List pgsql-general
Hello all,

I'm experimenting with JSON-path functions, and stumbled upon this query:

  SELECT jsonb_path_query('[1,2,3]', '$[*]?(@ == 4)')

It returns 0 rows. I expected it to return one row with `null` value. Isn't it the case that `SELECT <some expression>` should always return 1 row?

Viliam

pgsql-general by date:

Previous
From: Laura Smith
Date:
Subject: Re: Open SSL Version Query
Next
From: Thomas Kellerer
Date:
Subject: Re: Unexpected zero results