Skip to content

Commit 0d2a78b

Browse files
author
Thomas G. Lockhart
committed
Repair markup to allow clean doc builds.
1 parent e711278 commit 0d2a78b

File tree

3 files changed

+433
-436
lines changed

3 files changed

+433
-436
lines changed

‎doc/src/sgml/advanced.sgml

Lines changed: 45 additions & 40 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/advanced.sgml,v 1.13 2000/06/09 01:43:55 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/advanced.sgml,v 1.14 2000/06/14 13:12:52 thomas Exp $
33
-->
44

55
<chapter id="advanced">
@@ -59,21 +59,22 @@ CREATE TABLE capitals (
5959
The inheritance hierarchy is a directed acyclic graph.
6060
</para>
6161
</note>
62+
</para>
6263

63-
<para>
64-
For example, the following query finds the names of all cities,
65-
including state capitals, that are located at an altitude
66-
over 500ft, the query is:
64+
<para>
65+
For example, the following query finds the names of all cities,
66+
including state capitals, that are located at an altitude
67+
over 500ft, the query is:
6768

68-
<programlisting>
69-
SELECT c.name, c.altitude
69+
<programlisting>
70+
SELECT c.name, c.altitude
7071
FROM cities c
7172
WHERE c.altitude > 500;
72-
</programlisting>
73+
</programlisting>
7374

74-
which returns:
75+
which returns:
7576

76-
<programlisting>
77+
<programlisting>
7778
+----------+----------+
7879
|name | altitude |
7980
+----------+----------+
@@ -83,16 +84,16 @@ CREATE TABLE capitals (
8384
+----------+----------+
8485
|Madison | 845 |
8586
+----------+----------+
86-
</programlisting>
87-
</para>
87+
</programlisting>
88+
</para>
8889

89-
<para>
90-
On the other hand, the following query finds
91-
all the cities, but not capital cities
92-
that are situated at an attitude of 500ft or higher:
90+
<para>
91+
On the other hand, the following query finds
92+
all the cities, but not capital cities
93+
that are situated at an attitude of 500ft or higher:
9394

94-
<programlisting>
95-
SELECT name, altitude
95+
<programlisting>
96+
SELECT name, altitude
9697
FROM ONLY cities
9798
WHERE altitude &gt; 500;
9899

@@ -103,30 +104,34 @@ CREATE TABLE capitals (
103104
+----------+----------+
104105
|Mariposa | 1953 |
105106
+----------+----------+
106-
</programlisting>
107-
</para>
107+
</programlisting>
108+
</para>
108109

110+
<para>
111+
Here the <quote>ONLY</quote> before cities indicates that the query should
112+
be run over only cities and not classes below cities in the
113+
inheritance hierarchy. Many of the commands that we
114+
have already discussed -- <command>SELECT</command>,
115+
<command>UPDATE</command> and <command>DELETE</command> --
116+
support this <quote>ONLY</quote> notation.
117+
</para>
109118

110-
Here the <quote>ONLY</quote> before cities indicates that the query should
111-
be run over only cities and not classes below cities in the
112-
inheritance hierarchy. Many of the commands that we
113-
have already discussed -- <command>SELECT</command>,
114-
<command>UPDATE</command> and <command>DELETE</command> --
115-
support this <quote>ONLY</quote> notation.
116-
</para>
117-
<para>
118-
Deprecated: In previous versions of postgres, the default was not to
119-
get access to child classes. By experience this was found to be error
120-
prone. Under the old syntax, to get the sub-classes you append "*"
121-
to the table name. For example
122-
<programlisting>
123-
SELECT * from cities*;
124-
</programlisting>
125-
This old behaviour is still available by using a SET command...
126-
<programlisting>
127-
SET EXAMINE_SUBCLASS TO on;
128-
</programlisting>
129-
</para>
119+
<para>
120+
Deprecated: In previous versions of postgres, the default was not to
121+
get access to child classes. By experience this was found to be error
122+
prone. Under the old syntax, to get the sub-classes you append "*"
123+
to the table name. For example
124+
125+
<programlisting>
126+
SELECT * from cities*;
127+
</programlisting>
128+
129+
This old behaviour is still available by using a SET command:
130+
131+
<programlisting>
132+
SET EXAMINE_SUBCLASS TO on;
133+
</programlisting>
134+
</para>
130135
</sect1>
131136

132137
<sect1>

‎doc/src/sgml/inherit.sgml

Lines changed: 3 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/Attic/inherit.sgml,v 1.8 2000/06/09 01:43:56 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/Attic/inherit.sgml,v 1.9 2000/06/14 13:12:52 thomas Exp $
33
-->
44

55
<chapter id="inherit">
@@ -40,6 +40,7 @@ CREATE TABLE capitals UNDER cities (
4040
The inheritance hierarchy is a actually a directed acyclic graph.
4141
</para>
4242
</note>
43+
</para>
4344

4445
<para>
4546
For example, the following query finds the names of all cities,
@@ -87,6 +88,7 @@ CREATE TABLE capitals UNDER cities (
8788
</programlisting>
8889
</para>
8990

91+
<para>
9092
Here the <quote>ONLY</quote> before cities indicates that the query should
9193
be run over only cities and not classes below cities in the
9294
inheritance hierarchy. Many of the commands that we

0 commit comments

Comments
 (0)