From: Stéphane Raimbault <stephane.raimbault@deesse.univ-lemans.fr>
To: pgsql-docs@postgresql.org
Subject: Errors in tutorial
Date: 14 Nov 2001 23:26:19 +0100
Message-ID: <1005776412.1061.6.camel@trax.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: stephane.raimbault@deesse.univ-lemans.fr
Subject: Re: Errors in tutorial
In-Reply-To: <1005776412.1061.6.camel@trax.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox