aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2000-07-22 02:39:10 +0000
committerBruce Momjian <bruce@momjian.us>2000-07-22 02:39:10 +0000
commitec37ea1cc1356f1a0b7dad1d9e4933e50bea583f (patch)
treefcbe77155dad39128583d59e3f65392834edf6fe
parentbb13830d6f3e58fbb8340cbfd909d7f9e5cbdcb0 (diff)
downloadpostgresql-ec37ea1cc1356f1a0b7dad1d9e4933e50bea583f.tar.gz
postgresql-ec37ea1cc1356f1a0b7dad1d9e4933e50bea583f.zip
Cleanups
-rw-r--r--doc/src/sgml/ref/alter_group.sgml4
-rw-r--r--doc/src/sgml/ref/alter_table.sgml4
-rw-r--r--doc/src/sgml/ref/alter_user.sgml8
-rw-r--r--doc/src/sgml/ref/cluster.sgml4
-rw-r--r--doc/src/sgml/ref/copy.sgml4
-rw-r--r--doc/src/sgml/ref/create_function.sgml4
-rw-r--r--doc/src/sgml/ref/create_rule.sgml6
-rw-r--r--doc/src/sgml/ref/create_table.sgml4
-rw-r--r--doc/src/sgml/ref/fetch.sgml4
-rw-r--r--doc/src/sgml/ref/pg_upgrade.sgml4
-rw-r--r--doc/src/sgml/ref/update.sgml10
11 files changed, 30 insertions, 26 deletions
diff --git a/doc/src/sgml/ref/alter_group.sgml b/doc/src/sgml/ref/alter_group.sgml
index debbe979e1a..6fb399c1530 100644
--- a/doc/src/sgml/ref/alter_group.sgml
+++ b/doc/src/sgml/ref/alter_group.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.1 2000/01/14 22:11:32 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_group.sgml,v 1.2 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -114,7 +114,7 @@ ALTER GROUP <replaceable class="PARAMETER">name</replaceable> DROP USER <replace
ALTER GROUP staff ADD USER karl, john
</programlisting>
- Remove a user from a group
+ Remove a user from a group:
<programlisting>
ALTER GROUP workers DROP USER beth
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml
index 91f08a7885c..aa133b493bb 100644
--- a/doc/src/sgml/ref/alter_table.sgml
+++ b/doc/src/sgml/ref/alter_table.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.13 2000/06/09 01:43:57 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.14 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -307,7 +307,7 @@ CREATE TABLE temp AS SELECT did, city FROM distributors;
DROP TABLE distributors;
CREATE TABLE distributors (
did DECIMAL(3) DEFAULT 1,
- name VARCHAR(40) NOT NULL,
+ name VARCHAR(40) NOT NULL
);
INSERT INTO distributors SELECT * FROM temp;
DROP TABLE temp;
diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml
index d97648e0521..922633a74ab 100644
--- a/doc/src/sgml/ref/alter_user.sgml
+++ b/doc/src/sgml/ref/alter_user.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.11 2000/03/27 17:14:42 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.12 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -160,7 +160,7 @@ ERROR: ALTER USER: user "username" does not exist
ALTER USER davide WITH PASSWORD 'hu8jmn3';
</programlisting>
- Change a user's valid until date
+ Change a user's valid until date:
<programlisting>
ALTER USER manuel VALID UNTIL 'Jan 31 2030';
@@ -168,12 +168,12 @@ ALTER USER manuel VALID UNTIL 'Jan 31 2030';
Change a user's valid until date, specifying that his
authorisation should expire at midday on 4th May 1998 using
- the time zone which is one hour ahead of UTC
+ the time zone which is one hour ahead of UTC:
<programlisting>
ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';
</programlisting>
- Give a user the ability to create other users and new databases.
+ Give a user the ability to create other users and new databases:
<programlisting>
ALTER USER miriam CREATEUSER CREATEDB;
diff --git a/doc/src/sgml/ref/cluster.sgml b/doc/src/sgml/ref/cluster.sgml
index 2b66cf86907..3d7145c2dbf 100644
--- a/doc/src/sgml/ref/cluster.sgml
+++ b/doc/src/sgml/ref/cluster.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.7 1999/07/22 15:09:06 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/cluster.sgml,v 1.8 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -204,7 +204,7 @@ SELECT <replaceable class="parameter">columnlist</replaceable> INTO TABLE <repla
Usage
</title>
<para>
- Cluster the employees relation on the basis of its salary attribute
+ Cluster the employees relation on the basis of its salary attribute:
</para>
<programlisting>
CLUSTER emp_ind ON emp;
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index bdebff077b1..4772ad0530a 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.16 2000/04/18 23:44:58 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v 1.17 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -407,7 +407,7 @@ ERROR: <replaceable>reason</replaceable>
</title>
<para>
The following example copies a table to standard output,
- using a vertical bar ("|") as the field
+ using a pipe (|) as the field
delimiter:
</para>
<programlisting>
diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml
index 708d0745eec..e75d86cd2e0 100644
--- a/doc/src/sgml/ref/create_function.sgml
+++ b/doc/src/sgml/ref/create_function.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.13 2000/03/27 17:14:42 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_function.sgml,v 1.14 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -293,7 +293,7 @@ CREATE TABLE product (
find a type conversion function automatically, the sql function has
to have the same name as the return type, and overloading is
unavoidable. The function name is overloaded by using the second
- form of the <command>AS</command> clause in the SQL definition
+ form of the <command>AS</command> clause in the SQL definition:
</para>
<programlisting>
CREATE FUNCTION point(complex) RETURNS point
diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml
index e8be3823045..12be4c87e40 100644
--- a/doc/src/sgml/ref/create_rule.sgml
+++ b/doc/src/sgml/ref/create_rule.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.17 2000/07/21 04:22:54 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_rule.sgml,v 1.18 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -203,7 +203,7 @@ ON UPDATE TO emp-1.salary WHERE emp-2.name = "Joe"
report an error because the query cycled too many times:
<example>
- <title>Example of a circular rewrite rule combination.</title>
+ <title>Example of a circular rewrite rule combination:</title>
<programlisting>
CREATE RULE bad_rule_combination_1 AS
ON SELECT TO emp
@@ -220,7 +220,7 @@ CREATE RULE bad_rule_combination_2 AS
<para>
This attempt to select from EMP will cause
<productname>Postgres</productname> to issue an error
- because the queries cycled too many times.
+ because the queries cycled too many times:
<programlisting>
SELECT * FROM emp;
</programlisting></para>
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index dd23c1f40e0..7dc04b0aaf4 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.31 2000/07/14 15:27:14 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.32 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -221,7 +221,7 @@ ERROR: DEFAULT: type mismatched
<para>
<note>
<para>
- As of Postgres version 6.0, consistent array dimensions within an
+ Consistent array dimensions within an
attribute are not enforced. This will likely change in a future
release.
</para>
diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml
index 89b3831b598..6c0edfd0745 100644
--- a/doc/src/sgml/ref/fetch.sgml
+++ b/doc/src/sgml/ref/fetch.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/fetch.sgml,v 1.10 2000/05/11 17:32:33 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/fetch.sgml,v 1.11 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -355,7 +355,7 @@ COMMIT WORK;
<para>
<acronym>SQL92</acronym> allows absolute positioning of the cursor for
- FETCH, and allows placing the results into explicit variables.
+ FETCH, and allows placing the results into explicit variables:
<synopsis>
FETCH ABSOLUTE <replaceable class="PARAMETER">#</replaceable>
diff --git a/doc/src/sgml/ref/pg_upgrade.sgml b/doc/src/sgml/ref/pg_upgrade.sgml
index 879f53d540d..64a2e91b75d 100644
--- a/doc/src/sgml/ref/pg_upgrade.sgml
+++ b/doc/src/sgml/ref/pg_upgrade.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pg_upgrade.sgml,v 1.10 2000/07/21 00:24:37 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/Attic/pg_upgrade.sgml,v 1.11 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -78,7 +78,7 @@ $ pg_dumpall -s >db.out
<step performance="required">
<para>
- Do
+ Do:
<programlisting>
$ make install
</programlisting>
diff --git a/doc/src/sgml/ref/update.sgml b/doc/src/sgml/ref/update.sgml
index 85da5c1f2d2..035e3adb224 100644
--- a/doc/src/sgml/ref/update.sgml
+++ b/doc/src/sgml/ref/update.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/update.sgml,v 1.10 2000/06/09 01:44:00 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/update.sgml,v 1.11 2000/07/22 02:39:10 momjian Exp $
Postgres documentation
-->
@@ -157,8 +157,12 @@ UPDATE <replaceable class="parameter">#</replaceable>
Change word "Drama" with "Dramatic" on column kind:
<programlisting>
-UPDATE films SET kind = 'Dramatic' WHERE kind = 'Drama';
-SELECT * FROM films WHERE kind = 'Dramatic' OR kind = 'Drama';
+UPDATE films
+SET kind = 'Dramatic'
+WHERE kind = 'Drama';
+SELECT *
+FROM films
+WHERE kind = 'Dramatic' OR kind = 'Drama';
code | title | did | date_prod | kind | len
-------+---------------+-----+------------+----------+-------