Re: [GENERAL] [Q] Update from a table

2013-12-05 Thread Ladislav Lenart
On 5.12.2013 15:14, Tom Lane wrote: > Ladislav Lenart writes: >> What happens if I issue UPDATE SET FROM... but with incomplete/buggy WHERE >> condition and thus SEVERAL rows from the from_list match ONE row to update? > > Any given row will be updated at most once. However, the from_list row >

Re: [GENERAL] [Q] Update from a table

2013-12-05 Thread Tom Lane
Ladislav Lenart writes: > What happens if I issue UPDATE SET FROM... but with incomplete/buggy WHERE > condition and thus SEVERAL rows from the from_list match ONE row to update? Any given row will be updated at most once. However, the from_list row it gets updated against will be unpredictable,