Errors in tutorial - Mailing list pgsql-docs

From Stéphane Raimbault
Subject Errors in tutorial
Date
Msg-id 1005776412.1061.6.camel@trax.org
Whole thread Raw
Responses Re: Errors in tutorial
List 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


pgsql-docs by date:

Previous
From: Justin Clift
Date:
Subject: Re: techdocs "Essential Databasing Terminology" link
Next
From: Luis Amigo
Date:
Subject: bug?? on oid2name