Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5F7974759EA for ; Wed, 15 May 2002 04:59:35 -0400 (EDT) Received: from mail.iinet.net.au (symphony-06.iinet.net.au [203.59.3.38]) by postgresql.org (Postfix) with SMTP id EB72A475873 for ; Wed, 15 May 2002 04:59:32 -0400 (EDT) Received: (qmail 14732 invoked by uid 666); 15 May 2002 08:59:26 -0000 Received: from unknown (HELO beldin) (203.59.235.2) by iinet.net.au with SMTP; 15 May 2002 08:59:26 -0000 Message-ID: <006101c1fbef$3c1e0380$02eb3bcb@beldin> Reply-To: "Lennart Goedhart" From: "Lennart Goedhart" To: Subject: Typo in PG 7.2.1 Tutorial PDF Date: Wed, 15 May 2002 17:02:26 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005E_01C1FC32.49D31860" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200205/14 X-Sequence-Number: 1372 This is a multi-part message in MIME format. ------=_NextPart_000_005E_01C1FC32.49D31860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Section 3.3 - Foreign Keys CREATE TABLE weather ( city varchar(80) references weather, temp_lo int, temp_hi int, prcp real, date date ); Should read: CREATE TABLE weather ( city varchar(80) references cities, temp_lo int, temp_hi int, prcp real, date date ); Lennart Goedhart ------=_NextPart_000_005E_01C1FC32.49D31860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Section 3.3 - Foreign Keys
 
CREATE TABLE weather (
    city varchar(80) refere= nces=20 weather,
    temp_lo int,
    temp_hi int,
    prcp real,
    date date
);
 
 
Should read:
 
CREATE TABLE= weather=20 (
    city varchar(80) refere= nces=20 cities,
    temp_lo int,
    temp_hi int,
    prcp real,
    date date
);
 
 
Lennart=20 Goedhart
 ------=_NextPart_000_005E_01C1FC32.49D31860--