Re: [GENERAL] Strange/Correct? behavior of SELECT FOR UPDATE

2016-01-22 Thread Adrian Klaver
On 01/22/2016 01:41 AM, david.tu...@linuxbox.cz wrote: Hi, we have some question about behavior SELECT FOR UPDATE. We want find record with open bounds tstzrange, close it a insert new open. We use SELECT FOR UPDATE in function, but sometimes 2rows inserted. I show this on simple example with

[GENERAL] Strange/Correct? behavior of SELECT FOR UPDATE

2016-01-22 Thread david . turon
Hi, we have some question about behavior SELECT FOR UPDATE. We want find record with open bounds tstzrange, close it a insert new open. We use SELECT FOR UPDATE in function, but sometimes 2rows inserted. I show this on simple example with integer data type. Here is: --tested on postgresql