Commit5645a6a

committed

tutorial: land height is "elevation", not "altitude"

This is a follow-on patch to92c12e4. 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-altitudeThis renames the tutorial SQL files to match the documentation.Reported-by: max1@inbox.ruDiscussion:https://postgr.es/m/161512392887.1046.3137472627109459518@wrigleys.postgresql.orgBackpatch-through: 9.6

1 parent74207b8 commit5645a6aCopy full SHA for 5645a6a

File tree

-6

lines changed

-6

lines changed

Lines changed: 6 additions & 6 deletions

Original file line number	Diff line number	Diff line change
`@@ -23,7 +23,7 @@`
`23`	`23`	`CREATE TABLE cities (`
`24`	`24`	`nametext,`
`25`	`25`	`populationfloat8,`
`26`		`-altitudeint-- (in ft)`
	`26`	`+elevationint-- (in ft)`
`27`	`27`	`);`
`28`	`28`
`29`	`29`	`CREATE TABLE capitals (`
`@@ -42,17 +42,17 @@ SELECT * FROM cities;`
`42`	`42`	`SELECT * FROM capitals;`
`43`	`43`
`44`	`44`	`-- You can find all cities, including capitals, that`
`45`		`--- are located at analtitude of 500 ft or higher by:`
	`45`	`+-- are located at anelevation of 500 ft or higher by:`
`46`	`46`
`47`		`-SELECT c.name, c.altitude`
	`47`	`+SELECT c.name, c.elevation`
`48`	`48`	`FROM cities c`
`49`		`-WHERE c.altitude > 500;`
	`49`	`+WHERE c.elevation > 500;`
`50`	`50`
`51`	`51`	`-- To scan rows of the parent table only, use ONLY:`
`52`	`52`
`53`		`-SELECT name,altitude`
	`53`	`+SELECT name,elevation`
`54`	`54`	`FROM ONLY cities`
`55`		`-WHEREaltitude > 500;`
	`55`	`+WHEREelevation > 500;`
`56`	`56`
`57`	`57`
`58`	`58`	`-- clean up (you must remove the children first)`

Comments

(0)