Commit6099bc0

committed

Adjust documentation examples to match recent error message rewordings.

A couple other minor fixes.

1 parent444af9e commit6099bc0Copy full SHA for 6099bc0

File tree

+15

-13

lines changed

+15

-13

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/advanced.sgml,v 1.36 2003/09/1222:17:18 tgl Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/advanced.sgml,v 1.37 2003/09/30 03:22:32 tgl Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter id="tutorial-advanced">`
`@@ -123,8 +123,8 @@ INSERT INTO weather VALUES ('Berkeley', 45, 53, 0.0, '1994-11-28');`
`123`	`123`	`</programlisting>`
`124`	`124`
`125`	`125`	`<screen>`
`126`		`-ERROR: insert or update on "weather" violates foreign key constraint "$1"`
`127`		`-DETAIL: Key (city)=(Berkeley) is not present in "cities".`
	`126`	`+ERROR: insert or update ontable"weather" violates foreign key constraint "$1"`
	`127`	`+DETAIL: Key (city)=(Berkeley) is not present intable"cities".`
`128`	`128`	`</screen>`
`129`	`129`	`</para>`
`130`	`130`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.175 2003/09/20 20:12:04 tgl Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.176 2003/09/30 03:22:33 tgl Exp $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -6422,7 +6422,7 @@ SELECT ... WHERE CASE WHEN x <> 0 THEN y/x > 1.5 ELSE false END;`
`6422`	`6422`	`</indexterm>`
`6423`	`6423`
`6424`	`6424`	`<synopsis>`
`6425`		`-<function>coalesce</function>(<replaceable>value</replaceable> <optional>, ...</optional>)`
	`6425`	`+<function>COALESCE</function>(<replaceable>value</replaceable> <optional>, ...</optional>)`
`6426`	`6426`	`</synopsis>`
`6427`	`6427`
`6428`	`6428`	`<para>`
`@@ -7610,7 +7610,7 @@ SELECT min(col) FROM sometable;`
`7610`	`7610`	`Fortunately, there is a simple workaround for`
`7611`	`7611`	`<function>min()</function> and <function>max()</function>. The`
`7612`	`7612`	`query shown below is equivalent to the query above, except that it`
`7613`		`- can take advantage of a B+-Tree index if there is one present on`
	`7613`	`+ can take advantage of a B-tree index if there is one present on`
`7614`	`7614`	`the column in question.`
`7615`	`7615`	`<programlisting>`
`7616`	`7616`	`SELECT col FROM sometable ORDER BY col ASC LIMIT 1;`

Lines changed: 6 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.44 2003/09/11 21:42:19 momjian Exp $ -->`
	`1`	`+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.45 2003/09/30 03:22:33 tgl Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="indexes">`
`4`	`4`	`<title id="indexes-title">Indexes</title>`
`@@ -722,9 +722,11 @@ CREATE UNIQUE INDEX tests_success_constraint ON tests (subject, target)`
`722`	`722`	`Although indexes in <productname>PostgreSQL</> do not need`
`723`	`723`	`maintenance and tuning, it is still important to check`
`724`	`724`	`which indexes are actually used by the real-life query workload.`
`725`		`- Examining index usage is done with the <command>EXPLAIN</> command;`
`726`		`- its application for this purpose is illustrated in <xref`
`727`		`- linkend="using-explain">.`
	`725`	`+ Examining index usage for an individual query is done with the`
	`726`	`+ <command>EXPLAIN</> command; its application for this purpose is`
	`727`	`+ illustrated in <xref linkend="using-explain">.`
	`728`	`+ It is also possible to gather overall statistics about index usage`
	`729`	`+ in a running server, as described in <xref linkend="monitoring-stats">.`
`728`	`730`	`</para>`
`729`	`731`
`730`	`732`	`<para>`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`2`		`-$Header: /cvsroot/pgsql/doc/src/sgml/typeconv.sgml,v 1.34 2003/09/1222:17:24 tgl Exp $`
	`2`	`+$Header: /cvsroot/pgsql/doc/src/sgml/typeconv.sgml,v 1.35 2003/09/30 03:22:33 tgl Exp $`
`3`	`3`	`-->`
`4`	`4`
`5`	`5`	`<chapter Id="typeconv">`
`@@ -434,7 +434,7 @@ not some other type was used:`
`434`	`434`	`<screen>`
`435`	`435`	`SELECT @ '-4.5e500' AS "abs";`
`436`	`436`
`437`		`-ERROR: "-4.5e500" is out of range forfloat8`
	`437`	`+ERROR: "-4.5e500" is out of range fortype double precision`
`438`	`438`	`</screen>`
`439`	`439`	`</para>`
`440`	`440`
`@@ -447,7 +447,7 @@ SELECT '20' ! AS "factorial";`
`447`	`447`
`448`	`448`	`ERROR: operator is not unique: "unknown" !`
`449`	`449`	`HINT: Could not choose a best candidate operator. You may need to add explicit`
`450`		`-typecasts.`
	`450`	`+type casts.`
`451`	`451`	`</screen>`
`452`	`452`	`This happens because the system can't decide which of the several`
`453`	`453`	`possible <literal>!</> operators should be preferred. We can help`

Comments

(0)