Extend syntax wish: FOR [KEY] UPDATE - Mailing list pgsql-general

From Denis Feklushkin
Subject Extend syntax wish: FOR [KEY] UPDATE
Date
Msg-id CAHY2gWde-XNVMSRRN+-rR7iXoGtkMWsSZNDV8V2=e4MU2C52zw@mail.gmail.com
Whole thread Raw
List 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: No POSTGIS in PostgreSQL 18
Next
From: Ashish Mukherjee
Date:
Subject: Re: Downgrade pgsql 17 to pgsql 12 question