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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-11-14 22:50:50 | Re: techdocs "Essential Databasing Terminology" link |
Previous Message | Robert B. Easter | 2001-11-14 22:10:59 | techdocs "Essential Databasing Terminology" link |