Re: Removing unneeded self joins - Mailing list pgsql-hackers

From Alexander Kuzmenkov
Subject Re: Removing unneeded self joins
Date
Msg-id fa5ce779-2200-702f-85ec-780f1769cd66@postgrespro.ru
Whole thread Raw
In response to Re: Removing unneeded self joins  (Alexander Kuzmenkov <a.kuzmenkov@postgrespro.ru>)
Responses Re: Removing unneeded self joins
List pgsql-hackers
I noticed you lost a couple of test cases in v14, so I added them back.

I also added a case where your implementation returns a different number 
of rows compared to vanilla:

select * from sl t1, sl t2 where t1.a = t2.a and t1.b = 1;

Please see the attached v15.

-- 
Alexander Kuzmenkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Re: using index or check in ALTER TABLE SET NOT NULL
Next
From: Robert Haas
Date:
Subject: renaming ExecStoreWhateverTuple