aboutsummaryrefslogtreecommitdiff
path: root/src/tutorial/advanced.source
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2021-03-10 20:25:19 -0500
committerBruce Momjian <bruce@momjian.us>2021-03-10 20:25:19 -0500
commit2950ff32f31d073ea4be4f5f9b73249131f42bd7 (patch)
tree415386b0e3339cbf5de25227414c91559cc6cf17 /src/tutorial/advanced.source
parent5f8727f5a679452f7bbdd6966a1586934dcaa84f (diff)
downloadpostgresql-2950ff32f31d073ea4be4f5f9b73249131f42bd7.tar.gz
postgresql-2950ff32f31d073ea4be4f5f9b73249131f42bd7.zip
tutorial: land height is "elevation", not "altitude"
This is a follow-on patch to 92c12e46d5. 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
Diffstat (limited to 'src/tutorial/advanced.source')
-rw-r--r--src/tutorial/advanced.source12
1 files changed, 6 insertions, 6 deletions
diff --git a/src/tutorial/advanced.source b/src/tutorial/advanced.source
index 1130784d4dc..0c68b3344c3 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)