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.
