Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.


pgsql-docs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group