Commit10f400c

committed

Fixes for examples from Thomas Diffenbach

1 parent8fdd794 commit10f400cCopy full SHA for 10f400c

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.13 2000/11/29 20:15:59 petere Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/sql.sgml,v 1.14 2000/12/09 22:59:25 momjian Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter id="sql">`
`@@ -934,7 +934,7 @@ SELECT PNAME, PRICE`
`934`	`934`	`SELECT PNAME, PRICE`
`935`	`935`	`FROM PART`
`936`	`936`	`WHERE PNAME = 'Bolt' AND`
`937`		`- (PRICE = 0 OR PRICE < 15);`
	`937`	`+ (PRICE = 0 OR PRICE <= 15);`
`938`	`938`	`</programlisting>`
`939`	`939`
`940`	`940`	`will lead to the result:`
`@@ -1350,7 +1350,7 @@ SELECT S.SNO, S.SNAME, S.CITY`
`1350`	`1350`	`INTERSECT`
`1351`	`1351`	`SELECT S.SNO, S.SNAME, S.CITY`
`1352`	`1352`	`FROM SUPPLIER S`
`1353`		`- WHERE S.SNO> 2;`
	`1353`	`+ WHERE S.SNO< 3;`
`1354`	`1354`	`</programlisting>`
`1355`	`1355`
`1356`	`1356`	`gives the result:`
`@@ -1624,7 +1624,7 @@ CREATE VIEW London_Suppliers`
`1624`	`1624`
`1625`	`1625`	`<programlisting>`
`1626`	`1626`	`SELECT * FROM London_Suppliers`
`1627`		`- WHEREP.PNAME = 'Screw';`
	`1627`	`+ WHERE PNAME = 'Screw';`
`1628`	`1628`	`</programlisting>`
`1629`	`1629`
`1630`	`1630`	`which will return the following table:`

Comments

(0)