advanced.sql tutorial script

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: max1(at)inbox(dot)ru
Subject: advanced.sql tutorial script
Date: 2021-03-07 13:32:08
Message-ID: 161512392887.1046.3137472627109459518@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2021-03-07 14:14:07 Re: INNER JOIN syntax is not commonly used?
Previous Message Pavel Stehule 2021-03-07 12:05:43 Re: INNER JOIN syntax is not commonly used?