pg.ddx.io pgsql-docs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
advanced.sql tutorial script 2+ messages / 2 participants [nested] [flat]
* advanced.sql tutorial script @ 2021-03-07 13:32 PG Doc comments form <noreply@postgresql.org> 2021-03-11 01:27 ` Re: advanced.sql tutorial script Bruce Momjian <bruce@momjian.us> 0 siblings, 1 reply; 2+ messages in thread From: PG Doc comments form @ 2021-03-07 13:32 UTC (permalink / raw) To: pgsql-docs@lists.postgresql.org; +Cc: max1@inbox.ru 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: advanced.sql tutorial script 2021-03-07 13:32 advanced.sql tutorial script PG Doc comments form <noreply@postgresql.org> @ 2021-03-11 01:27 ` Bruce Momjian <bruce@momjian.us> 0 siblings, 0 replies; 2+ messages in thread From: Bruce Momjian @ 2021-03-11 01:27 UTC (permalink / raw) To: max1@inbox.ru; pgsql-docs@lists.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:^ permalink raw reply [nested|flat] 2+ messages in threadmaster.diff (text/x-diff, 920B) download
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)
end of thread, other threads:[~2021-03-11 01:27 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-03-07 13:32 advanced.sql tutorial script PG Doc comments form <noreply@postgresql.org> 2021-03-11 01:27 ` Bruce Momjian <bruce@momjian.us>
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