Hi,
Is it technically possible for there to be a "select for insert"? e.g.
other select for inserts with the same effective where clause will block
even if no rows are there yet.
Or should select .. for update actually work that way? I think it's
probably too difficult to implement it tho.
What cases would it be useful for select ... for update to _not_ block
other select ... for updates when no rows exist yet?
Are there RDBMSes with a command to atomically update if stuff already
exists, and insert if it doesn't?
Would anyone else find this useful?
Cheerio,
Link.
