Unexpected extra row from jsonb_path_query() with a recursive path

From: Jan Przemysław Wójcik <jan(dot)przemyslaw(dot)wojcik(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Unexpected extra row from jsonb_path_query() with a recursive path
Date: 2019-12-08 11:43:18
Message-ID: CA+YsLFo6=voUdskxNcnJdqN4Z+Kck-5t0MxcJNtecNZ5Sws9YA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PostgreSQL 12.1, compiled by Visual C++ build 1914, 64-bit
Windows 10

Query:

select jsonb_path_query('{"data": [{"key": "value"}]}', '$.**.key')

Actual output:

jsonb_path_query
------------------
"value"
"value"
(2 rows)

Expected output:

jsonb_path_query
------------------
"value"
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrey Lepikhov 2019-12-09 03:49:26 Warning in the RecordTransactionAbort routine during compilation with O3 flag
Previous Message Alexander Law 2019-12-07 21:00:00 Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows)