Skip site navigation (1) Skip section navigation (2)

Errors in tutorial

From: St├ęphane Raimbault <stephane(dot)raimbault(at)deesse(dot)univ-lemans(dot)fr>
To: pgsql-docs(at)postgresql(dot)org
Subject: Errors in tutorial
Date: 2001-11-14 22:26:19
Message-ID: 1005776412.1061.6.camel@trax.org (view raw or flat)
Thread:
Lists: 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  


Responses

pgsql-docs by date

Next:From: Bruce MomjianDate: 2001-11-14 22:50:50
Subject: Re: techdocs "Essential Databasing Terminology" link
Previous:From: Robert B. EasterDate: 2001-11-14 22:10:59
Subject: techdocs "Essential Databasing Terminology" link

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group