Re: SELECT ... FOR UPDATE OF clause documentation implies use of table_names rather than aliases

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: SELECT ... FOR UPDATE OF clause documentation implies use of table_names rather than aliases
Date: 2023-11-21 03:20:57
Message-ID: CAKFQuwYVRJg9mdCSVKCdSpEoWnje9jxEiFfvOsX3Kr+_uG2NbA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Mon, Nov 20, 2023 at 8:16 PM Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Mon, Nov 20, 2023 at 07:19:39PM -0700, David G. Johnston wrote:
> > The placement in the numbered listing section feels wrong, I am OK with
> > the wording. It should be down in the clause details.
> >
> > FOR lock_strength [ OF from_reference [, ...] ] [ NOWAIT | SKIP LOCKED
> ] --
> > need to change this spot to match
> >
> > where lock_strength can be one of
> >
> > [...]
> >
> > + and from_reference must be a table alias or non-hidden table_name
> referenced
> > in the FROM clause.
> >
> > For more information on each [...]
>
> Ah, good point. I was searching for "FOR UPDATE" so I missed that
> section; updated patch attached.
>
>
WFM.

Thanks!

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2023-11-21 21:49:37 Re: Documentation of FOR ROLE clause of ALTER DEFAULT PRIVILEGES missing
Previous Message Bruce Momjian 2023-11-21 03:16:04 Re: SELECT ... FOR UPDATE OF clause documentation implies use of table_names rather than aliases