Received: from hotmail.com (f60.law4.hotmail.com [216.33.149.60])
	by postgresql.org (Postfix) with ESMTP id B29A7474E42
	for <pgsql-docs@postgresql.org>; Sat, 30 Mar 2002 09:57:03 -0500 (EST)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Sat, 30 Mar 2002 06:57:07 -0800
Received: from 213.42.0.243 by lw4fd.law4.hotmail.msn.com with HTTP;
	Sat, 30 Mar 2002 14:57:07 GMT
X-Originating-IP: [213.42.0.243]
From: "Cepera - n/a -" <cepera@hotmail.com>
To: pgsql-docs@postgresql.org
Subject: Seems a mistake in tutorial-7.2-A4.pdf file
Date: Sat, 30 Mar 2002 14:57:07 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F60W7huV7L7lSmdtzms00010c9a@hotmail.com>
X-OriginalArrivalTime: 30 Mar 2002 14:57:07.0774 (UTC)
	FILETIME=[2998FDE0:01C1D7FB]
X-Archive-Number: 200204/1
X-Sequence-Number: 1326

Hi,

I'm learning psql reading tutorial-7.2-A4.pdf file and doing
exercise from this document.
It seems there is a mistake in it.
On pages 14-15 of mentioned document it's written:

...<page 14>
The new declaration of the tables would look like this:

CREATE TABLE cities (
name varchar(80) primary key,
location point
);
                                                          14
...<page 15>
                                Chapter 3. Advanced Features

CREATE TABLE weather (
city varchar(80) references weather,
temp_lo int,
temp_hi int,
prcp real,
date date
);

Now try inserting an invalid record:
...


IMHO line `city varchar(80) references weather,'
must be   `city varchar(80) references cities,'.

Best regards,
Serge.


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com