Extend syntax wish: FOR [KEY] UPDATE

From: Denis Feklushkin <feklushkin(dot)denis(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Extend syntax wish: FOR [KEY] UPDATE
Date: 2025-09-30 07:31:57
Message-ID: CAHY2gWde-XNVMSRRN+-rR7iXoGtkMWsSZNDV8V2=e4MU2C52zw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Mukherjee 2025-09-30 08:23:23 Re: Downgrade pgsql 17 to pgsql 12 question
Previous Message Adrian Klaver 2025-09-29 19:23:16 Re: No POSTGIS in PostgreSQL 18