From 49d7165117893405ae9b5b8d8e7877acff33c0e7 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Fri, 4 Sep 2020 08:45:57 +0200 Subject: doc: Change table alias names to lower case in tutorial chapter This is needlessly different from our usual style otherwise. Author: Jürgen Purtz Discussion: https://www.postgresql.org/message-id/flat/158996922318.7035.10603922579567326239@wrigleys.postgresql.org --- src/tutorial/basics.source | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'src/tutorial/basics.source') diff --git a/src/tutorial/basics.source b/src/tutorial/basics.source index 9dbd75eb154..fe1cdfde2a8 100644 --- 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; ----------------------------- -- cgit v1.2.3