Received: from firewall2.hants.gov.uk (gatekeeper2.hants.gov.uk [195.166.69.31]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBCFgqm88752 for ; Tue, 12 Dec 2000 10:42:53 -0500 (EST) (envelope-from itdcgb@its.hants.gov.uk) Received: from [172.16.1.19] (helo=hants.gov.uk) by firewall2.hants.gov.uk with esmtp (Exim 3.15 #1) id 145ra8-0006BH-00 for pgsql-docs@postgresql.org; Tue, 12 Dec 2000 15:43:08 +0000 Received: from [172.16.1.212] (HELO mailbox.hants.gov.uk) by hants.gov.uk (CommuniGate Pro SMTP 3.3.1) with ESMTP id 1539446 for pgsql-docs@postgresql.org; Tue, 12 Dec 2000 15:43:08 +0000 X-WebMail-UserID: itdcgb@its.hants.gov.uk Date: Tue, 12 Dec 2000 15:33:28 +0000 From: itdcgb To: pgsql-docs@postgresql.org X-EXP32-SerialNo: 00002674 Subject: Tutorial: chapter 5 Message-ID: <3A25384D@mailbox.hants.gov.uk> Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit X-Mailer: WebMail (Hydra) SMTP v3.61 X-Archive-Number: 200012/30 X-Sequence-Number: 77 In 'Joins between classes' in Section 5 of the tutorial we have, in the first paragraph: As an example, say we wish to find all the records that are in the temperature range of other records. In effect, we need to compare the temp_lo and temp_hi attributes of each EMP instance to the temp_lo and temp_hi attributes of all other EMP instances. I believe that EMP should read WEATHER, as the example query that follows joins WEATHER to itself. EMP is often used in Oracle examples. Regards, Graham