Horton

Re: Foreign Keys being able to reference same table not spelled out in documentation

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: maweki@gmail.com, Pg Docs <pgsql-docs@lists.postgresql.org>
Date: 2021-05-06T04:17:05Z
Lists: pgsql-docs 
On Thu, Apr 29, 2021 at 10:33 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I'm inclined to propose adding an example a little further down, as
> per the attached draft patch.  This wouldn't help people who stop
> reading after the section's first sentence, but we can't cover
> everything in the first sentence.
>
>
Given the tutorial nature of this section I agree with the approach.

I did a read through of the patch and I like it; though I suggest changing
"but non-NULL" to "while non-NULL".

Thanks!

David J.

Commits

  1. Doc: trivial wording adjustment.

  2. Doc: add an example of a self-referential foreign key to ddl.sgml.