Thread: Error in documentation

Error in documentation

From
amoroder@sb-brixen.it (andreas moroder)
Date:
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

Re: Error in documentation

From
Bruce Momjian
Date:
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