diff options
| author | Bruce Momjian <bruce@momjian.us> | 2021-07-02 20:42:46 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2021-07-02 20:42:46 -0400 |
| commit | 437d74f498c82c8a620db4991f9066a89964aa9d (patch) | |
| tree | acbf5800d072d49255a54c43662752d261e25a80 | |
| parent | feff6155734e75d9471bb84319afb6f9ca114686 (diff) | |
| download | postgresql-437d74f498c82c8a620db4991f9066a89964aa9d.tar.gz postgresql-437d74f498c82c8a620db4991f9066a89964aa9d.zip | |
doc: adjust "cities" example to be consistent with other SQL
Reported-by: tom@crystae.net
Discussion: https://postgr.es/m/162345756191.14472.9754568432103008703@wrigleys.postgresql.org
Backpatch-through: 9.6
| -rw-r--r-- | doc/src/sgml/advanced.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/advanced.sgml b/doc/src/sgml/advanced.sgml index 2d4ab85d450..71ae423f631 100644 --- a/doc/src/sgml/advanced.sgml +++ b/doc/src/sgml/advanced.sgml @@ -46,7 +46,7 @@ <programlisting> CREATE VIEW myview AS - SELECT city, temp_lo, temp_hi, prcp, date, location + SELECT name, temp_lo, temp_hi, prcp, date, location FROM weather, cities WHERE city = name; @@ -101,12 +101,12 @@ SELECT * FROM myview; <programlisting> CREATE TABLE cities ( - city varchar(80) primary key, + name varchar(80) primary key, location point ); CREATE TABLE weather ( - city varchar(80) references cities(city), + city varchar(80) references cities(name), temp_lo int, temp_hi int, prcp real, |