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 <br...@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: t...@cornell.edu
Discussion:
https://postgr.es/m/158506544539.679.2278386310645558...@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 <br...@momjian.us> https://momjian.us
EDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
diff --git a/src/tutorial/advanced.source b/src/tutorial/advanced.source
index 1130784d4d..0c68b3344c 100644
--- a/src/tutorial/advanced.source
+++ b/src/tutorial/advanced.source
@@ -23,7 +23,7 @@
CREATE TABLE cities (
name text,
population float8,
- altitude int -- (in ft)
+ elevation int -- (in ft)
);
CREATE TABLE capitals (
@@ -42,17 +42,17 @@ SELECT * FROM cities;
SELECT * FROM capitals;
-- You can find all cities, including capitals, that
--- are located at an altitude of 500 ft or higher by:
+-- are located at an elevation of 500 ft or higher by:
-SELECT c.name, c.altitude
+SELECT c.name, c.elevation
FROM cities c
-WHERE c.altitude > 500;
+WHERE c.elevation > 500;
-- To scan rows of the parent table only, use ONLY:
-SELECT name, altitude
+SELECT name, elevation
FROM ONLY cities
-WHERE altitude > 500;
+WHERE elevation > 500;
-- clean up (you must remove the children first)
