Unexpected zero results

From: Viliam Ďurina <viliam(dot)durina(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Unexpected zero results
Date: 2022-03-23 16:56:09
Message-ID: CAO=iB8K_AJe-x7gZSCS+ndTAsE2XUj8+i7rP5UHxvUO6cMySBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2022-03-23 17:00:46 Re: Unexpected zero results
Previous Message Laura Smith 2022-03-23 14:23:55 Re: Open SSL Version Query