Date: Thu, 7 Dec 2023 19:43:17 -0500
From: Bruce Momjian <bruce@momjian.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: SELECT ... FOR UPDATE OF clause documentation implies use of
 table_names rather than aliases
Message-ID: <ZXJmpe__WfBZgKX2@momjian.us>
References: <152483686904.19805.3369061025704720797@wrigleys.postgresql.org>
 <ZVflgb-C2xAmdgBC@momjian.us>
 <CAKFQuwa9CX11j5AZSp0Hk16wwW7474hhWHsCEGg1-dMsa4Mg+g@mail.gmail.com>
 <ZVwQHCA85qhKPUcG@momjian.us>
 <CAKFQuwb=PnpzD=k7wWyWNdE2NnExw0kLpYcpOOC4P_EHdC8Wtw@mail.gmail.com>
 <ZVwg9AP4Zvj3RR1J@momjian.us>
 <CAKFQuwYVRJg9mdCSVKCdSpEoWnje9jxEiFfvOsX3Kr+_uG2NbA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAKFQuwYVRJg9mdCSVKCdSpEoWnje9jxEiFfvOsX3Kr+_uG2NbA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZXJmpe__WfBZgKX2%40momjian.us>
Precedence: bulk

On Mon, Nov 20, 2023 at 08:20:57PM -0700, David G. Johnston wrote:
> On Mon, Nov 20, 2023 at 8:16 PM Bruce Momjian <bruce@momjian.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.

Patch applied to master.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.