On Mon, Feb 15, 2016 at 3:17 PM, Nikolai Zhubr <n-a-zhubr(at)yandex(dot)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.