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.