Re: Minor errors in example \tutorial\sql-languaged.htm; Corrected

Поиск
Список
Период
Сортировка
Искать

Re: Minor errors in example \tutorial\sql-languaged.htm; Corrected

От:
Bruce Momjian <pgman@candle.pha.pa.us>
Дата:
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);
> 842                                       !>    WHERE S.SNO > 2;
> 1350                                   !>    WHERE P.PNAME = 'Screw';
> 1808         
> 1809          1810         (Minor corrections to example SQL made by Thomas Paul
> Diffenbach,
> 1811         (tp@diffenbach.org),
> 9 December 2000)

> 1812 1813 !> >
> 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); will lead to the result: --- 934,940 ---- SELECT PNAME, PRICE FROM PART WHERE PNAME = 'Bolt' AND ! (PRICE = 0 OR PRICE <= 15); will lead to the result: *************** *** 1350,1356 **** INTERSECT SELECT S.SNO, S.SNAME, S.CITY FROM SUPPLIER S ! WHERE S.SNO > 2; gives the result: --- 1350,1356 ---- INTERSECT SELECT S.SNO, S.SNAME, S.CITY FROM SUPPLIER S ! WHERE S.SNO < 3; gives the result: *************** *** 1624,1630 **** SELECT * FROM London_Suppliers ! WHERE P.PNAME = 'Screw'; which will return the following table: --- 1624,1630 ---- SELECT * FROM London_Suppliers ! WHERE PNAME = 'Screw'; which will return the following table:
FAQ