From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: watermelonmania79@gmail.com
Subject: 3.6 Inheritance Documentation
Date: Wed, 02 Aug 2023 19:54:08 +0000
Message-ID: <169100604868.635.1178692927881377748@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/tutorial-inheritance.html
Description:
The documentation for inheritance in PostgreSQL is not entirely accurate in
the given example.
In the provided example, the cities table and the capitals table have a
parent-child relationship through inheritance. However, querying the cities
table directly (e.g., SELECT name, elevation FROM cities WHERE elevation >
500;) will not automatically include data from the child table, capitals.
Inheritance in PostgreSQL does not implicitly combine data from parent and
child tables in a single query.
To include data from both the parent and child tables, a UNION or other join
operations must be used, as I previously explained.
The documentation should be corrected to clarify that inheritance does not
automatically combine data from parent and child tables when querying the
parent table directly. It might be updated to provide a better example
demonstrating the use of UNION or JOIN operations to retrieve data from both
parent and child tables.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, watermelonmania79@gmail.com
Subject: Re: 3.6 Inheritance Documentation
In-Reply-To: <169100604868.635.1178692927881377748@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox