Re: Grammar suggestion

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "dilerie01(at)gmail(dot)com" <dilerie01(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Grammar suggestion
Date: 2024-01-08 15:19:06
Message-ID: CAKFQuwYEqi_Jit67XOtqe7a=MZv+k2fchxk_Qh=PRJ0S5B4p9Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Monday, January 8, 2024, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/15/ddl-constraints.html
> Description:
>
> Dear postgres Team,
>
> I happened to have stumbled across a tricky to read sentence in Ch. 5.45
> 'Foreign Keys' (Postgres Version 15).
>
> The original sentence: "Normally, a referencing row need not satisfy the
> foreign key constraint if any of its referencing columns are null".
>
> Here's the revised version: "Normally, a referencing row does not need to
> satisfy the foreign key constraint if any of its referencing columns are
> null."
>
> A bit restructuring in beginning of this sentence can it make it
> grammatically complete and clear for the reader.
>

I see where you are coming from but I think the word “need” is actual
problem and it has to go. We use the phrase “escapes satisfying” in the
subsequent sentence and should use it here too.

Normally, a referencing row escapes satisfying the foreign key constraint
if any of its referencing columns are null. [add: This is what is meant by
match simple]. If match full is …

Also, we go to the trouble of accepting “match partial”. Maybe add a final
sentence in this paragraph nothing that we do so and explaining what
partial is defined to mean in the standard? Also, we only note the not
implemented in the syntax parameters area, not the compatibility area…this
seems like an oversight.

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2024-01-08 15:37:21 Re: Grammar suggestion
Previous Message PG Doc comments form 2024-01-08 13:31:36 Grammar suggestion