pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedErrors in tutorial
2+ messages / 2 participants
[nested] [flat]
* Errors in tutorial
@ 2001-11-14 22:26 Stéphane Raimbault <stephane.raimbault@deesse.univ-lemans.fr>
2001-11-18 21:29 ` Re: Errors in tutorial Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Stéphane Raimbault @ 2001-11-14 22:26 UTC (permalink / raw)
To: pgsql-docs
Hi,
My version is
version
-------------------------------------------------------------
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96
from Red Hat 7.1.
I found 3 errors in your tutorial
(postgresql-7.0.3/tutorial/sql-language.htm)
testdb=# SELECT PNAME, PRICE
testdb-# FROM PART
testdb-# WHERE PNAME = 'Bolt' AND
testdb-# (PRICE = 0 OR PRICE < 15);
pname | price
-------+-------
(0 rows)
and not
PNAME | PRICE
--------+--------
Bolt | 15
because PRICE is strictly < to 15.
testdb=# SELECT S.SNO, S.SNAME, S.CITY
testdb-# FROM SUPPLIER S
testdb-# WHERE S.SNO > 1
testdb-# INTERSECT
testdb-# SELECT S.SNO, S.SNAME, S.CITY
testdb-# FROM SUPPLIER S
testdb-# WHERE S.SNO > 2;
sno | sname | city
-----+-------+--------
3 | Adams | Vienna
4 | Blake | Rome
(2 rows)
and not this result:
SNO | SNAME | CITY
-----+-------+--------
2 | Jones | Paris
You must also replace this request
SELECT *
FROM London_Suppliers
WHERE P.PNAME = 'Screw';
by
testdb=# SELECT *
testdb-# FROM London_Suppliers
testdb-# WHERE PNAME='Screw';
sname | pname
-------+-------
Smith | Screw
(1 row)
else you will raise this :
ERROR: Relation 'p' does not exist
In
file:///usr/share/doc/postgresql-7.0.3/programmer/libpq-chapter3939.htm#AEN3949
I found this error
#include "utils/geo-decls.h" /* for the POLYGON type */
instead of
#include "utils/geo_decls.h" /* for the POLYGON type */
Nevertheless, you do a good job around postgres, thank you for your docs.
Bye
Stephane
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Errors in tutorial
2001-11-14 22:26 Errors in tutorial Stéphane Raimbault <stephane.raimbault@deesse.univ-lemans.fr>
@ 2001-11-18 21:29 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2001-11-18 21:29 UTC (permalink / raw)
To: Stéphane Raimbault <stephane.raimbault@deesse.univ-lemans.fr>; +Cc: pgsql-docs
=?ISO-8859-1?Q?St=E9phane?= Raimbault <stephane.raimbault@deesse.univ-lemans.fr> writes:
> [ various typos in 7.0.3 docs ]
Thanks for the report! The first three of these had already been found
and fixed in 7.1 docs, but the "geo-decls" error was still there ...
it's fixed for 7.2.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-11-18 21:29 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-14 22:26 Errors in tutorial Stéphane Raimbault <stephane.raimbault@deesse.univ-lemans.fr>
2001-11-18 21:29 ` 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