Re: [HACKERS] Left lateral join with for update and skip locked

2015-03-18 Thread Alvaro Herrera
Benjamin Börngen-Schmidt wrote: > The Lateral statement does return a result, which I do not expect. I returns > an end point multiple times for diverent start points. Why? I thought, that > the selected point by the lateral is locked by the FOR UPDATE and if the > lateral selects a point that is

Re: [HACKERS] Left lateral join with for update and skip locked

2015-03-18 Thread Tom Lane
=?UTF-8?B?QmVuamFtaW4gQsO2cm5nZW4tU2NobWlkdA==?= writes: > The Lateral statement does return a result, which I do not expect. I > returns an end point multiple times for diverent start points. Why? I > thought, that the selected point by the lateral is locked by the FOR > UPDATE and if the lat