Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB9Mx6Z59996
	for <pgsql-docs@postgresql.org>; Sat, 9 Dec 2000 17:59:06 -0500 (EST)
	(envelope-from pgman@candle.pha.pa.us)
Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id
 RAA00520;
	Sat, 9 Dec 2000 17:58:57 -0500 (EST)
From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200012092258.RAA00520@candle.pha.pa.us>
Subject: Re: Minor errors in example \tutorial\sql-languaged.htm; Corrected
In-Reply-To: <PJEGLHAEFKDLDDOMAMEKOEGMCDAA.tpdiffenbach@yahoo.com>
	"from Thomas Paul Diffenbach at Dec 9, 2000 05:36:07 pm"
To: tp@diffenbach.org
Date: Sat, 9 Dec 2000 17:58:57 -0500 (EST)
CC: PostgreSQL-documentation <pgsql-docs@postgresql.org>
X-Mailer: ELM [version 2.4ME+ PL77 (25)]
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=ELM976402737-29628-0_
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200012/15
X-Sequence-Number: 62

--ELM976402737-29628-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Thanks very much for the fixes.  I have attached the diff against our
current documentation reflecting your changes.

[ Charset ISO-8859-1 unsupported, converting... ]
> Dear Mr. Momjian,
> 
> As this isn?t quite a bug report, and as you?re listed as the FAQ
> maintainer, and as I can?t find a more general mailto:, I am sending this to
> you. If there is a more appropriate recipient, my apologies, and please let
> me know where to send this.
> 
> I?ve installed PostgreSQL, and am in awe. While I?ve not had time to even
> read all the manuals, I?m amazed that it provides so much functionality.
> Thanks!
> 
> In order to determine how much of the SQL language PostgresSQL supports, I
> went through the tutorial, which I found to be quite rigorous in its
> treatment of SQL theory. However, I did notice that some of the examples had
> minor errors. I have changed the queries to produce the intended results
> sets. The changes produce this diff:
> 
> Comparing: pgsql\doc\tutorial\sql-language-revised.htm
> To: pgsql\doc\tutorial\sql-language.htm
> ====
> ====
> 338             <!          (PRICE = 0 OR PRICE &#60;= 15);
>                          !>          (PRICE = 0 OR PRICE &#60; 15);
> 842             <!    WHERE S.SNO &#60; 3;
>                          !>    WHERE S.SNO &#62; 2;
> 1350         <!    WHERE PNAME = 'Screw';
>                          !>    WHERE P.PNAME = 'Screw';
> 1808         <! >
> 1809         <!
> 1810         <! <P>(Minor corrections to example SQL made by Thomas Paul
> Diffenbach,
> 1811         <! <A HREF="mailto:tp@diffenbach.org">(tp@diffenbach.org)</A>,
> 9 December 2000)</P>
> 1812         <!
> 1813         <! <DIV
>                          !> ><DIV
> 
> I have attached the corrected .html file; please feel free to use it as you
> see fit.
> 
> Thanks,
> --Thomas Diffenbach

[ Attachment, skipping... ]


-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

--ELM976402737-29628-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
Content-Disposition: inline; filename="/bjm/diff"

? config.log
? config.cache
? config.status
? GNUmakefile
? src/Makefile.custom
? src/GNUmakefile
? src/Makefile.global
? src/log
? src/crtags
? src/backend/port/Makefile
? src/include/config.h
? src/include/stamp-h
Index: doc/src/sgml/sql.sgml
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml/sql.sgml,v
retrieving revision 1.13
diff -c -r1.13 sql.sgml
*** doc/src/sgml/sql.sgml	2000/11/29 20:15:59	1.13
--- doc/src/sgml/sql.sgml	2000/12/09 22:57:43
***************
*** 934,940 ****
  SELECT PNAME, PRICE 
      FROM PART
      WHERE PNAME = 'Bolt' AND
!          (PRICE = 0 OR PRICE < 15);
  	</programlisting>
  
  	will lead to the result:
--- 934,940 ----
  SELECT PNAME, PRICE 
      FROM PART
      WHERE PNAME = 'Bolt' AND
!          (PRICE = 0 OR PRICE <= 15);
  	</programlisting>
  
  	will lead to the result:
***************
*** 1350,1356 ****
      INTERSECT
      SELECT S.SNO, S.SNAME, S.CITY
      FROM SUPPLIER S
!     WHERE S.SNO > 2;
  	</programlisting>
  
  	gives the result:
--- 1350,1356 ----
      INTERSECT
      SELECT S.SNO, S.SNAME, S.CITY
      FROM SUPPLIER S
!     WHERE S.SNO < 3;
  	</programlisting>
  
  	gives the result:
***************
*** 1624,1630 ****
  
        <programlisting>
  SELECT * FROM London_Suppliers
!     WHERE P.PNAME = 'Screw';
        </programlisting>
  
        which will return the following table:
--- 1624,1630 ----
  
        <programlisting>
  SELECT * FROM London_Suppliers
!     WHERE PNAME = 'Screw';
        </programlisting>
  
        which will return the following table:

--ELM976402737-29628-0_--