Tutorial documentation bug

Поиск
Список
Период
Сортировка
От Mikael Suokas
Тема Tutorial documentation bug
Дата
Msg-id Pine.OSF.4.10.10010061727200.24588-100000@alpha.hut.fi
обсуждение исходный текст
Список 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.


В списке pgsql-docs по дате отправления:

Предыдущее
От: PASAD
Дата:
Сообщение: Query from sindhu
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: Query from sindhu