Re: advanced.sql tutorial script

On Sun, Mar 7, 2021 at 01:32:08PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/tutorial-advanced-intro.html
> Description:
>
> I built tutorial files according to instructions from the section 2.1. And I
> found that the script advanced.sql covers only the section "3.6.
> Inheritance". There are no any statements related to "3.2. Views", "3.3.
> Foreign Keys", "3.4. Transactions" and "3.5. Window Functions".
> Also there is a difference between the script and the documentation in
> relation to Inheritance.
>
> In src/tutorial/advanced.sql:
> CREATE TABLE cities (
> name text,
> population float8,
> altitude int -- (in ft)
> );
>
> In documentation
> https://www.postgresql.org/docs/13/tutorial-inheritance.html :
> CREATE TABLE cities (
> name text,
> population real,
> elevation int -- (in ft)
> );
>
> So, advanced.sql should be updated with statements from sections 3.2-3.5 and
> with new table structures from 3.6.

Oops, I updated the docs to use "elevation" in this patch:

commit 92c12e46d5
Author: Bruce Momjian <bruce(at)momjian(dot)us>
Date: Wed Apr 22 16:23:19 2020 -0400

docs: land height is "elevation", not "altitude"

See https://mapscaping.com/blogs/geo-candy/what-is-the-difference-between-elevation-relief-and-altitude
No patching of regression tests.

Reported-by: taf1(at)cornell(dot)edu

Discussion: https://postgr.es/m/158506544539.679.2278386310645558048@wrigleys.postgresql.org

Backpatch-through: 9.5

but missed the tutorial mention. This is fixed in the attached, applied
patch. Thanks for the report.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

The usefulness of a cup is in its emptiness, Bruce Lee