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:
