Commitd390bb6

committed

doc: adjust "cities" example to be consistent with other SQL

1 parentc552e17 commitd390bb6Copy full SHA for d390bb6

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -46,7 +46,7 @@`
`46`	`46`
`47`	`47`	`<programlisting>`
`48`	`48`	`CREATE VIEW myview AS`
`49`		`- SELECTcity, temp_lo, temp_hi, prcp, date, location`
	`49`	`+ SELECTname, temp_lo, temp_hi, prcp, date, location`
`50`	`50`	`FROM weather, cities`
`51`	`51`	`WHERE city = name;`
`52`	`52`
`@@ -101,12 +101,12 @@ SELECT * FROM myview;`
`101`	`101`
`102`	`102`	`<programlisting>`
`103`	`103`	`CREATE TABLE cities (`
`104`		`-city varchar(80) primary key,`
	`104`	`+name varchar(80) primary key,`
`105`	`105`	`location point`
`106`	`106`	`);`
`107`	`107`
`108`	`108`	`CREATE TABLE weather (`
`109`		`- city varchar(80) references cities(city),`
	`109`	`+ city varchar(80) references cities(name),`
`110`	`110`	`temp_lo int,`
`111`	`111`	`temp_hi int,`
`112`	`112`	`prcp real,`

Comments

(0)