On Mon, Feb 15, 2016 at 3:17 PM, Nikolai Zhubr <n-a-zh...@yandex.ru> wrote:
> Hello all, > > I can't find any clear description of how to reliably figure and/or > enforce specific row (locking) order within UPDATE and SELECT FOR UPDATE > statements dealing with multiple rows. SQL is a set-oriented language. Sets do not have order. Therefore I don't understand your goal. That said subqueries and ORDER BY may be solution. David J.