Skip to content

Commit b6b1d72

Browse files
committed
tutorial: land height is "elevation", not "altitude"
This is a follow-on patch to 92c12e4. In that patch, we renamed "altitude" to "elevation" in the docs, based on these details: https://mapscaping.com/blogs/geo-candy/what-is-the-difference-between-elevation-relief-and-altitude This renames the tutorial SQL files to match the documentation. Reported-by: max1@inbox.ru Discussion: https://postgr.es/m/161512392887.1046.3137472627109459518@wrigleys.postgresql.org Backpatch-through: 9.6
1 parent c7a4fc3 commit b6b1d72

File tree

1 file changed

+6
-6
lines changed

1 file changed

+6
-6
lines changed

src/tutorial/advanced.source

+6-6
Original file line numberDiff line numberDiff line change
@@ -23,7 +23,7 @@
2323
CREATE TABLE cities (
2424
name text,
2525
population float8,
26-
altitude int -- (in ft)
26+
elevation int -- (in ft)
2727
);
2828

2929
CREATE TABLE capitals (
@@ -42,17 +42,17 @@ SELECT * FROM cities;
4242
SELECT * FROM capitals;
4343

4444
-- You can find all cities, including capitals, that
45-
-- are located at an altitude of 500 ft or higher by:
45+
-- are located at an elevation of 500 ft or higher by:
4646

47-
SELECT c.name, c.altitude
47+
SELECT c.name, c.elevation
4848
FROM cities c
49-
WHERE c.altitude > 500;
49+
WHERE c.elevation > 500;
5050

5151
-- To scan rows of the parent table only, use ONLY:
5252

53-
SELECT name, altitude
53+
SELECT name, elevation
5454
FROM ONLY cities
55-
WHERE altitude > 500;
55+
WHERE elevation > 500;
5656

5757

5858
-- clean up (you must remove the children first)

0 commit comments

Comments
 (0)