Re: Minor errors in example \tutorial\sql-languaged.htm; Corrected - Mailing list pgsql-docs

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 <= 15);
>                          !>          (PRICE = 0 OR PRICE < 15);
> 842             <!    WHERE S.SNO < 3;
>                          !>    WHERE S.SNO > 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
? 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: