Subject: Errors in tutorial
From: =?ISO-8859-1?Q?St=E9phane?= Raimbault
	<stephane.raimbault@deesse.univ-lemans.fr>
To: pgsql-docs@postgresql.org
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1005776412.1061.6.camel@trax.org>
Mime-Version: 1.0
Date: 14 Nov 2001 23:26:19 +0100

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