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.
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 |