Обсуждение: Extend syntax wish: FOR [KEY] UPDATE

Поиск
Список
Период
Сортировка

Extend syntax wish: FOR [KEY] UPDATE

От
Denis Feklushkin
Дата:
Hi! I have an idea.

I think there's some historical confusion near to FOR UPDATE in a SELECT statement, because this should be called FOR KEY UPDATE or something like.

It's currently impossible to rename it, but it's possible to introduce optional keyword KEY:

FOR [KEY] UPDATE

Those pedants who care about avoiding confusion with FOR NO KEY UPDATE will start using this optional word and code will look clearer.