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

2015-03-18 Thread Tom Lane
=?UTF-8?B?QmVuamFtaW4gQsO2cm5nZW4tU2NobWlkdA==?= benja...@boerngen-schmidt.de 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

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

2015-03-18 Thread Benjamin Börngen-Schmidt
A few days ago I posted a question on general concerning the new feature SKIP LOCKED in PostgreSQL 9.5-dev. For the orginal question can be found here: http://www.postgresql.org/message-id/54f723c3.1020...@boerngen-schmidt.de What I'm trying to archieve is to match a point from my data

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