pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Seems a mistake in tutorial-7.2-A4.pdf file
2+ messages / 2 participants
[nested] [flat]

* Seems a mistake in tutorial-7.2-A4.pdf file
@ 2002-03-30 14:57  Cepera - n/a - <cepera@hotmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Cepera - n/a - @ 2002-03-30 14:57 UTC (permalink / raw)
  To: pgsql-docs

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Seems a mistake in tutorial-7.2-A4.pdf file
@ 2002-04-02 20:44  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Cepera - n/a - <cepera@hotmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2002-04-02 20:44 UTC (permalink / raw)
  To: Cepera - n/a - <cepera@hotmail.com>; +Cc: pgsql-docs

"Cepera - n/a -" <cepera@hotmail.com> writes:
> IMHO line `city varchar(80) references weather,'
> must be   `city varchar(80) references cities,'.

Yup, you're right.  This is fixed in current sources (for 7.3).
Thanks...

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-04-02 20:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-30 14:57 Seems a mistake in tutorial-7.2-A4.pdf file Cepera - n/a - <cepera@hotmail.com>
2002-04-02 20:44 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox