From: Bruce Momjian <bruce@momjian.us>
To: max1@inbox.ru
To: pgsql-docs@lists.postgresql.org
Subject: Re: advanced.sql tutorial script
Date: Wed, 10 Mar 2021 20:27:06 -0500
Message-ID: <20210311012705.GD11261@momjian.us> (raw)
In-Reply-To: <161512392887.1046.3137472627109459518@wrigleys.postgresql.org>
References: <161512392887.1046.3137472627109459518@wrigleys.postgresql.org>
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: 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@momjian.us> https://momjian.us
EDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
Attachments:master.diff (text/x-diff, 920B) downloaddiff --git a/src/tutorial/advanced.source b/src/tutorial/advanced.sourceindex 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)
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: bruce@momjian.us, max1@inbox.ru, pgsql-docs@lists.postgresql.org
Subject: Re: advanced.sql tutorial script
In-Reply-To: <20210311012705.GD11261@momjian.us>
* 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