Re: subselect removes rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Poot, Bas (B(dot)J(dot))" <bas(dot)poot(at)politie(dot)nl>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: subselect removes rows
Date: 2021-11-29 17:34:48
Message-ID: 1268251.1638207288@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Poot, Bas (B.J.)" <bas(dot)poot(at)politie(dot)nl> writes:
> The problem is that I don't expect (and can't imagine it is correct) that a (any) sub-select removes rows from the resultset.

I'm really not sure what you're saying here. If you're complaining
about jsonb_each_text returning no rows for empty input, that behavior
hasn't changed, and it's hard to see what else it could do. Your
example isn't showing any other behavior that seems odd.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pantelis Theodosiou 2021-11-29 17:47:27 Re: subselect removes rows
Previous Message Poot, Bas (B.J.) 2021-11-29 15:44:54 Re: subselect removes rows