advanced.sql tutorial script
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.
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@momjian.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@cornell.edu
Discussion: /messages/by-id/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@momjian.us> https://momjian.us
EDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee