Обсуждение: 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

=?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