Error in documentation
Hello,
in the tutorial ( HTML and PDF ) I found the folowing example
The new declaration of the tables would look like this:
CREATE TABLE cities (
name varchar(80) primary key,
location point
);
Chapter 3. Advanced Features
CREATE TABLE weather (
city varchar(80) references weather,
temp_lo int,
temp_hi int,
prcp real,
date date
);
Is this ok should the reference not be "references cities" ?
Bye
Andreas
Yes, I we already fixed this. Don't remember if the fix is in 7.2.
In fact, I see this:
revision 1.27
date: 2002/02/12 22:25:15; author: momjian; state: Exp; lines: +3 -3
Fix tutorial for references problem, from rainer.tammer@spg.schulergroup.com
which means it didn't make it into 7.2. It should be OK in the online
docs, and in 7.3.
---------------------------------------------------------------------------
andreas moroder wrote:
Hello,
in the tutorial ( HTML and PDF ) I found the folowing example
The new declaration of the tables would look like this:
CREATE TABLE cities (
name varchar(80) primary key,
location point
);Chapter 3. Advanced Features
CREATE TABLE weather (
city varchar(80) references weather,
temp_lo int,
temp_hi int,
prcp real,
date date
);Is this ok should the reference not be "references cities" ?
Bye
Andreas---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026