Tutorial documentation bug

From: Mikael Suokas <csuokas(at)cc(dot)hut(dot)fi>
To: pgsql-docs(at)postgresql(dot)org
Subject: Tutorial documentation bug
Date: 2000-10-06 14:54:50
Message-ID: Pine.OSF.4.10.10010061727200.24588-100000@alpha.hut.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs


Hi,

While reading the tutorial at
http://www.postgresql.org/docs/tutorial/sql-language.htm
I came across a bug.

In Chapter 2, Example 2-9.: "Union, Intersect, Except"
the tutorial states:

-------------- start quote ------------------
Here an example for INTERSECT:

SELECT S.SNO, S.SNAME, S.CITY
FROM SUPPLIER S
WHERE S.SNO > 1
INTERSECT
SELECT S.SNO, S.SNAME, S.CITY
FROM SUPPLIER S
WHERE S.SNO > 2;

gives the result:

SNO | SNAME | CITY
-----+-------+--------
2 | Jones | Paris

The only tuple returned by both parts of the query is the one having
$SNO=2$.

---------------- end quote -------------------

The result is really:

sno | sname | city
-----+-------+--------
3 | Adams | Vienna
4 | Blake | Rome
(2 rows)

Kind regards,

- Mikael -

P.S. I am not on the pgsql-docs mailing list, so I won't
see any replies sent there.

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2000-10-07 22:03:56 S-Tree_indexes.html.gz
Previous Message Bruce Momjian 2000-10-05 14:28:12 Re: Re: [ANNOUNCE] Announce: Release of PyGreSQL version 3.0