On Wed, May 17, 2017 at 8:38 PM, Heikki Linnakangas wrote:
>
> As a final note, I found an interesting paper called "Unnesting Arbitrary
> Queries", by Thomas Neumann and Alfons Kemper
> (http://www.btw-2015.de/res/proceedings/Hauptband/Wiss/Neumann-Unnesting_Arbitrary_Querie.pdf).
> It describes
On 18 May 2017 at 04:30, Robert Haas wrote:
> On Wed, May 17, 2017 at 11:08 AM, Heikki Linnakangas wrote:
>> That's not a straight semi-join, but we could still turn it into a new kind
>> of LEFT-SEMI join. A left-semi join is like a left join, in that it returns
>> all rows from the left side, a
On Wed, May 17, 2017 at 11:08 AM, Heikki Linnakangas wrote:
> That's not a straight semi-join, but we could still turn it into a new kind
> of LEFT-SEMI join. A left-semi join is like a left join, in that it returns
> all rows from the left side, and NULLs for any non-matches. And like a
> semi-jo
