Re: subselect removes rows - Mailing list pgsql-bugs

From Tom Lane
Subject Re: subselect removes rows
Date
Msg-id 1268251.1638207288@sss.pgh.pa.us
Whole thread Raw
In response to Re: subselect removes rows  ("Poot, Bas (B.J.)" <bas.poot@politie.nl>)
Responses Re: subselect removes rows
List pgsql-bugs
"Poot, Bas (B.J.)" <bas.poot@politie.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



pgsql-bugs by date:

Previous
From: "Poot, Bas (B.J.)"
Date:
Subject: Re: subselect removes rows
Next
From: Pantelis Theodosiou
Date:
Subject: Re: subselect removes rows