doc: Change table alias names to lower case in tutorial chapter

petere · petere · commit 49d716511789 · 2020-09-04T08:45:57.000+02:00
This is needlessly different from our usual style otherwise. Author: Jürgen Purtz <juergen@purtz.de> Discussion: https://www.postgresql.org/message-id/flat/158996922318.7035.10603922579567326239@wrigleys.postgresql.org
diff --git a/doc/src/sgml/query.sgml b/doc/src/sgml/query.sgml
@@ -609,11 +609,11 @@ SELECT *
     following query:
 
 <programlisting>
-SELECT W1.city, W1.temp_lo AS low, W1.temp_hi AS high,
-    W2.city, W2.temp_lo AS low, W2.temp_hi AS high
-    FROM weather W1, weather W2
-    WHERE W1.temp_lo &lt; W2.temp_lo
-    AND W1.temp_hi &gt; W2.temp_hi;
+SELECT w1.city, w1.temp_lo AS low, w1.temp_hi AS high,
+    w2.city, w2.temp_lo AS low, w2.temp_hi AS high
+    FROM weather w1, weather w2
+    WHERE w1.temp_lo &lt; w2.temp_lo
+    AND w1.temp_hi &gt; w2.temp_hi;
 </programlisting>
 
 <screen>
@@ -624,8 +624,8 @@ SELECT W1.city, W1.temp_lo AS low, W1.temp_hi AS high,
 (2 rows)
 </screen>
 
-    Here we have relabeled the weather table as <literal>W1</literal> and
-    <literal>W2</literal> to be able to distinguish the left and right side
+    Here we have relabeled the weather table as <literal>w1</literal> and
+    <literal>w2</literal> to be able to distinguish the left and right side
     of the join.  You can also use these kinds of aliases in other
     queries to save some typing, e.g.:
 <programlisting>
diff --git a/src/tutorial/basics.source b/src/tutorial/basics.source
@@ -126,13 +126,13 @@ SELECT *
     FROM weather LEFT OUTER JOIN cities ON (weather.city = cities.name);
 
 -- Suppose we want to find all the records that are in the temperature range
--- of other records.  W1 and W2 are aliases for weather.
+-- of other records.  w1 and w2 are aliases for weather.
 
-SELECT W1.city, W1.temp_lo, W1.temp_hi,
-       W2.city, W2.temp_lo, W2.temp_hi
-FROM weather W1, weather W2
-WHERE W1.temp_lo < W2.temp_lo
-   and W1.temp_hi > W2.temp_hi;
+SELECT w1.city, w1.temp_lo, w1.temp_hi,
+       w2.city, w2.temp_lo, w2.temp_hi
+FROM weather w1, weather w2
+WHERE w1.temp_lo < w2.temp_lo
+   and w1.temp_hi > w2.temp_hi;
 
 
 -----------------------------
