Errors in tutorial

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