aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>2001-04-20 15:52:33 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>2001-04-20 15:52:33 +0000
commite6767a32053963a968f419256e3629ace5e8df2f (patch)
treed7aa055a8bb47aae65a5be6b56e87dcb533c468b
parent072174f94160a96a8afa96e81a467f88e799f7de (diff)
downloadpostgresql-e6767a32053963a968f419256e3629ace5e8df2f.tar.gz
postgresql-e6767a32053963a968f419256e3629ace5e8df2f.zip
Final markup for 7.1 hardcopy release. Mostly typo and table-fitting
adjustments. Note that many tables are being abused with *really* long description columns. Should probably shrink those columns to be more concise, and move some of the info to follow-on reference notes.
-rw-r--r--doc/src/sgml/Makefile4
-rw-r--r--doc/src/sgml/biblio.sgml12
-rw-r--r--doc/src/sgml/catalogs.sgml4
-rw-r--r--doc/src/sgml/charset.sgml4
-rw-r--r--doc/src/sgml/docguide.sgml15
-rw-r--r--doc/src/sgml/func.sgml177
-rw-r--r--doc/src/sgml/geqo.sgml4
-rw-r--r--doc/src/sgml/libpgeasy.sgml4
-rw-r--r--doc/src/sgml/mvcc.sgml3
-rw-r--r--doc/src/sgml/user-manag.sgml2
10 files changed, 117 insertions, 112 deletions
diff --git a/doc/src/sgml/Makefile b/doc/src/sgml/Makefile
index ad8c15aa78f..b3c95e69783 100644
--- a/doc/src/sgml/Makefile
+++ b/doc/src/sgml/Makefile
@@ -8,7 +8,7 @@
#
#
# IDENTIFICATION
-# $Header: /cvsroot/pgsql/doc/src/sgml/Makefile,v 1.35 2001/03/25 08:32:24 petere Exp $
+# $Header: /cvsroot/pgsql/doc/src/sgml/Makefile,v 1.36 2001/04/20 15:52:33 thomas Exp $
#
#----------------------------------------------------------------------------
@@ -20,7 +20,7 @@ include $(top_builddir)/src/Makefile.global
.NOTPARALLEL:
ifndef DOCBOOKSTYLE
-DOCBOOKSTYLE = /home/projects/pgsql/developers/thomas/db143.d/docbook
+DOCBOOKSTYLE = /home/projects/pgsql/developers/thomas/db162.d/docbook
endif
ifndef JADE
diff --git a/doc/src/sgml/biblio.sgml b/doc/src/sgml/biblio.sgml
index fc33e9bc8a1..fd97287870a 100644
--- a/doc/src/sgml/biblio.sgml
+++ b/doc/src/sgml/biblio.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.13 2000/05/02 20:01:51 thomas Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.14 2001/04/20 15:52:33 thomas Exp $
-->
<bibliography id="biblio">
@@ -236,7 +236,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.13 2000/05/02 20:01:51 thom
<surname>Lockhart</surname>
</editor>
- <pubdate>2000-05-01</pubdate>
+ <pubdate>2001-04-13</pubdate>
<publisher>
<publishername>The PostgreSQL Global Development Group</publishername>
</publisher>
@@ -262,7 +262,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.13 2000/05/02 20:01:51 thom
<surname>Lockhart</surname>
</editor>
- <pubdate>2000-05-01</pubdate>
+ <pubdate>2001-04-13</pubdate>
<publisher>
<publishername>The PostgreSQL Global Development Group</publishername>
</publisher>
@@ -288,7 +288,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.13 2000/05/02 20:01:51 thom
<surname>Lockhart</surname>
</editor>
- <pubdate>2000-05-01</pubdate>
+ <pubdate>2001-04-13</pubdate>
<publisher>
<publishername>The PostgreSQL Global Development Group</publishername>
</publisher>
@@ -314,7 +314,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.13 2000/05/02 20:01:51 thom
<surname>Lockhart</surname>
</editor>
- <pubdate>2000-05-01</pubdate>
+ <pubdate>2001-04-13</pubdate>
<publisher>
<publishername>The PostgreSQL Global Development Group</publishername>
</publisher>
@@ -340,7 +340,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/biblio.sgml,v 1.13 2000/05/02 20:01:51 thom
<surname>Lockhart</surname>
</editor>
- <pubdate>2000-05-01</pubdate>
+ <pubdate>2001-04-13</pubdate>
<publisher>
<publishername>The PostgreSQL Global Development Group</publishername>
</publisher>
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index c856c792b88..1738a5bf1d4 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -1,6 +1,6 @@
<!--
Documentation of the system catalogs, directed toward PostgreSQL developers
- $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.14 2001/03/24 23:03:26 petere Exp $
+ $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.15 2001/04/20 15:52:33 thomas Exp $
-->
<chapter id="catalogs">
@@ -1193,7 +1193,7 @@
<entry>lancompiler</entry>
<entry><type>text</type></entry>
<entry></entry>
- <entry>not useful</entry>
+ <entry>not currently used</entry>
</row>
</tbody>
</tgroup>
diff --git a/doc/src/sgml/charset.sgml b/doc/src/sgml/charset.sgml
index d348030e9e7..41301153f06 100644
--- a/doc/src/sgml/charset.sgml
+++ b/doc/src/sgml/charset.sgml
@@ -1,4 +1,4 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/charset.sgml,v 2.6 2001/01/19 04:47:50 tgl Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/charset.sgml,v 2.7 2001/04/20 15:52:33 thomas Exp $ -->
<chapter id="charset">
<title>Localization</>
@@ -108,7 +108,7 @@ export LANG=sv_SE
</row>
<row>
<entry>LC_CTYPE</>
- <entry>Character classification (What is a letter? What is the upper-case equivalent of this letter?)</>
+ <entry>Character classification (What is a letter? The upper-case equivalent?)</>
</row>
<row>
<entry>LC_MESSAGES</>
diff --git a/doc/src/sgml/docguide.sgml b/doc/src/sgml/docguide.sgml
index 893ea8d4632..192991c1964 100644
--- a/doc/src/sgml/docguide.sgml
+++ b/doc/src/sgml/docguide.sgml
@@ -1,4 +1,4 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/docguide.sgml,v 1.31 2001/02/17 16:52:53 tgl Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/docguide.sgml,v 1.32 2001/04/20 15:52:33 thomas Exp $ -->
<appendix label="DG2" id="docguide">
<title>Documentation</title>
@@ -36,8 +36,8 @@
</para>
<para>
- The documentation is organized into several <quote>books</quote>
- with varyingly confusing names:
+ The documentation is organized into several <quote>books</quote>:
+
<itemizedlist>
<listitem>
<para>
@@ -51,6 +51,11 @@
</listitem>
<listitem>
<para>
+ <citetitle>Reference Manual</citetitle>: documents the query language
+ </para>
+ </listitem>
+ <listitem>
+ <para>
<citetitle>Administrator's Guide</citetitle>: installation and server maintenance
</para>
</listitem>
@@ -68,8 +73,8 @@
</listitem>
</itemizedlist>
- All five books are available as HTML and Postscript. The
- <citetitle>User's Guide</citetitle> contains reference entries which
+ All books are available as HTML and Postscript. The
+ <citetitle>Reference Manual</citetitle> contains reference entries which
are also shipped as man pages.
</para>
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index d8dde6270ae..a22d1eb8d23 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -1,4 +1,4 @@
-<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.56 2001/03/25 18:14:31 tgl Exp $ -->
+<!-- $Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.57 2001/04/20 15:52:33 thomas Exp $ -->
<chapter id="functions">
<title>Functions and Operators</title>
@@ -440,15 +440,15 @@
<tbody>
<row>
<entry>abs(<replaceable>x</replaceable>)</entry>
- <entry>(same as argument type)</entry>
+ <entry>(same as x)</entry>
<entry>absolute value</entry>
<entry>abs(-17.4)</entry>
<entry>17.4</entry>
</row>
<row>
- <entry>cbrt(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
+ <entry>cbrt(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
<entry>cube root</entry>
<entry>cbrt(27.0)</entry>
<entry>3.0</entry>
@@ -463,17 +463,17 @@
</row>
<row>
- <entry>degrees(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
- <entry>convert radians to degrees</entry>
+ <entry>degrees(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
+ <entry>radians to degrees</entry>
<entry>degrees(0.5)</entry>
<entry>28.6478897565412</entry>
</row>
<row>
- <entry>exp(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
- <entry>exponential function</entry>
+ <entry>exp(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
+ <entry>exponential</entry>
<entry>exp(1.0)</entry>
<entry>2.71828182845905</entry>
</row>
@@ -487,25 +487,26 @@
</row>
<row>
- <entry>ln(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
+ <entry>ln(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
<entry>natural logarithm</entry>
<entry>ln(2.0)</entry>
<entry>0.693147180559945</entry>
</row>
<row>
- <entry>log(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
+ <entry>log(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
<entry>base 10 logarithm</entry>
<entry>log(100.0)</entry>
<entry>2.0</entry>
</row>
<row>
- <entry>log(<parameter>base</parameter> <type>numeric</type>, <parameter>x</parameter> <type>numeric</type>)</entry>
+ <entry>log(<parameter>b</parameter> <type>numeric</type>,
+ <parameter>x</parameter> <type>numeric</type>)</entry>
<entry><type>numeric</type></entry>
- <entry>logarithm to specified base</entry>
+ <entry>logarithm to base <parameter>b</parameter></entry>
<entry>log(2.0, 64.0)</entry>
<entry>6.0</entry>
</row>
@@ -513,55 +514,56 @@
<row>
<entry>mod(<parameter>y</parameter>, <parameter>x</parameter>)</entry>
<entry>(same as argument types)</entry>
- <entry>remainder (modulo) of the division <parameter>y</parameter>/<parameter>x</parameter></entry>
+ <entry>remainder of <parameter>y</parameter>/<parameter>x</parameter></entry>
<entry>mod(9,4)</entry>
<entry>1</entry>
</row>
<row>
<entry>pi()</entry>
- <entry><type>double precision</type></entry>
+ <entry><type>dp</type></entry>
<entry><quote>Pi</quote> constant</entry>
<entry>pi()</entry>
<entry>3.14159265358979</entry>
</row>
<row>
- <entry>pow(<type>double precision</type>, <type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
- <entry>raise a number to the specified exponent</entry>
+ <entry>pow(<parameter>e</parameter> <type>dp</type>,
+ <parameter>n</parameter> <type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
+ <entry>raise a number to exponent <parameter>e</parameter></entry>
<entry>pow(9.0, 3.0)</entry>
<entry>729.0</entry>
</row>
<row>
- <entry>radians(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
- <entry>convert degrees to radians</entry>
+ <entry>radians(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
+ <entry>degrees to radians</entry>
<entry>radians(45.0)</entry>
<entry>0.785398163397448</entry>
</row>
<row>
<entry>random()</entry>
- <entry><type>double precision</type></entry>
- <entry>a pseudo-random value between 0.0 to 1.0</entry>
+ <entry><type>dp</type></entry>
+ <entry>value between 0.0 to 1.0</entry>
<entry>random()</entry>
<entry></entry>
</row>
<row>
- <entry>round(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
+ <entry>round(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
<entry>round to nearest integer</entry>
<entry>round(42.4)</entry>
<entry>42</entry>
</row>
<row>
- <entry>round(<parameter>value</parameter> <type>numeric</type>, <parameter>scale</parameter> <type>integer</type>)</entry>
+ <entry>round(<parameter>v</parameter> <type>numeric</type>, <parameter>s</parameter> <type>integer</type>)</entry>
<entry><type>numeric</type></entry>
- <entry>round to specified number of decimal places</entry>
+ <entry>round to <parameter>s</parameter> decimal places</entry>
<entry>round(42.4382, 2)</entry>
<entry>42.44</entry>
</row>
@@ -574,25 +576,25 @@
</row>
-->
<row>
- <entry>sqrt(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
+ <entry>sqrt(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
<entry>square root</entry>
<entry>sqrt(2.0)</entry>
<entry>1.4142135623731</entry>
</row>
<row>
- <entry>trunc(<type>double precision</type>)</entry>
- <entry><type>double precision</type></entry>
- <entry>truncate (toward zero)</entry>
+ <entry>trunc(<type>dp</type>)</entry>
+ <entry><type>dp</type></entry>
+ <entry>truncate toward zero</entry>
<entry>trunc(42.8)</entry>
<entry>42</entry>
</row>
<row>
- <entry>trunc(<parameter>value</parameter> <type>numeric</type>, <parameter>scale</parameter> <type>integer</type>)</entry>
+ <entry>trunc(<type>numeric</type>, <parameter>s</parameter> <type>integer</type>)</entry>
<entry><type>numeric</type></entry>
- <entry>truncate to specified number of decimal places</entry>
+ <entry>truncate to <parameter>s</parameter> decimal places</entry>
<entry>round(42.4382, 2)</entry>
<entry>42.43</entry>
</row>
@@ -602,12 +604,16 @@
</table>
<para>
+ In the table above, "<literal>dp</literal>" indicates <type>double precision</type>.
The functions <function>exp</function>, <function>ln</function>,
<function>log</function>, <function>pow</function>,
<function>round</function> (1 argument), <function>sqrt</function>,
and <function>trunc</function> (1 argument) are also available for
the type <type>numeric</type> in place of <type>double
- precision</type>. Many of these functions are implemented on top
+ precision</type>.
+ Functions returning a <type>numeric</type> result take
+ <type>numeric</type> input arguments, unless otherwise specified.
+ Many of these functions are implemented on top
of the host system's C library and behavior in boundary cases could
therefore vary depending on the operating system.
</para>
@@ -800,7 +806,7 @@
<thead>
<row>
<entry>Function</entry>
- <entry>Return type</entry>
+ <entry>Return Type</entry>
<entry>Description</entry>
<entry>Example</entry>
<entry>Result</entry>
@@ -840,8 +846,8 @@
<entry>initcap(<type>text</type>)</entry>
<entry><type>text</type></entry>
<entry>Converts first letter of each word (whitespace separated) to upper case.</entry>
- <entry>initcap('hello thomas')</entry>
- <entry>Hello Thomas</entry>
+ <entry>initcap('hi thomas')</entry>
+ <entry>Hi Thomas</entry>
</row>
<row>
@@ -1362,9 +1368,14 @@
or bounded repetitions are nested. An RE like, say,
<literal>((((a{1,100}){1,100}){1,100}){1,100}){1,100}</literal>
will (eventually) run almost any existing machine out of swap
- space.<footnote><para>This was written in 1994, mind you. The
- numbers have probably changed, but the problem
- persists.</para></footnote>
+ space.
+ <footnote>
+ <para>
+ This was written in 1994, mind you. The
+ numbers have probably changed, but the problem
+ persists.
+ </para>
+ </footnote>
</para>
<!-- end re_format.7 man page -->
</sect2>
@@ -2026,8 +2037,8 @@
<entry><literal>'Good number: 485'</literal></entry>
</row>
<row>
- <entry>to_char(485.8,'"Pre-decimal:"999" Post-decimal:" .999')</entry>
- <entry><literal>'Pre-decimal: 485 Post-decimal: .800'</literal></entry>
+ <entry>to_char(485.8,'"Pre:"999" Post:" .999')</entry>
+ <entry><literal>'Pre: 485 Post: .800'</literal></entry>
</row>
<row>
<entry>to_char(12,'99V999')</entry>
@@ -2075,15 +2086,10 @@
</thead>
<tbody>
-<![IGNORE[
-<!--
-These two functions don't seem to do what it says here, or anything
-reasonable at all for that matter.
--->
<row>
<entry>age(timestamp)</entry>
<entry>interval</entry>
- <entry>Subtract argument from current date, preserve years and months and days</entry>
+ <entry>Subtract from today</entry>
<entry>age(timestamp '1957-06-13')</entry>
<entry>43 years 8 mons 3 days</entry>
</row>
@@ -2091,17 +2097,15 @@ reasonable at all for that matter.
<row>
<entry>age(timestamp, timestamp)</entry>
<entry>interval</entry>
- <entry>preserve months and years</entry>
- <entry>age('now', timestamp '1957-06-13')</entry>
- <entry></entry>
+ <entry>Subtract arguments</entry>
+ <entry>age('2001-04-10', timestamp '1957-06-13')</entry>
+ <entry>43 years 9 mons 27 days</entry>
</row>
-]]>
<row>
<entry>current_date</entry>
<entry>date</entry>
- <entry>
- returns current date; see also <link
+ <entry>Today's date; see <link
linkend="functions-datetime-current">below</link>
</entry>
<entry></entry>
@@ -2111,8 +2115,7 @@ reasonable at all for that matter.
<row>
<entry>current_time</entry>
<entry>time</entry>
- <entry>
- returns current time (of day); see also <link
+ <entry>Time of day; see <link
linkend="functions-datetime-current">below</link>
</entry>
<entry></entry>
@@ -2122,8 +2125,7 @@ reasonable at all for that matter.
<row>
<entry>current_timestamp</entry>
<entry>timestamp</entry>
- <entry>
- returns current date and time; see also <link
+ <entry>date and time; see also <link
linkend="functions-datetime-current">below</link>
</entry>
<entry></entry>
@@ -2133,8 +2135,7 @@ reasonable at all for that matter.
<row>
<entry>date_part(text, timestamp)</entry>
<entry>double precision</entry>
- <entry>
- extract subfield from date/time value (equivalent to
+ <entry>Get subfield (equivalent to
<function>extract</function>); see also <link
linkend="functions-datetime-datepart">below</link>
</entry>
@@ -2145,8 +2146,7 @@ reasonable at all for that matter.
<row>
<entry>date_part(text, interval)</entry>
<entry>double precision</entry>
- <entry>
- extract subfield from interval value (equivalent to
+ <entry>Get subfield (equivalent to
<function>extract</function>); see also <link
linkend="functions-datetime-datepart">below</link>
</entry>
@@ -2157,8 +2157,7 @@ reasonable at all for that matter.
<row>
<entry>date_trunc(text, timestamp)</entry>
<entry>timestamp</entry>
- <entry>
- truncate date to specified precision; see also <link
+ <entry>Truncate to specified precision; see also <link
linkend="functions-datetime-trunc">below</link>
</entry>
<entry>date_trunc('hour', timestamp '2001-02-16 20:38:40')</entry>
@@ -2166,10 +2165,9 @@ reasonable at all for that matter.
</row>
<row>
- <entry>extract(identifier from timestamp)</entry>
+ <entry>extract(<parameter>field</parameter> from timestamp)</entry>
<entry>double precision</entry>
- <entry>
- extract subfield from date/time value; see also <link
+ <entry>Get subfield; see also <link
linkend="functions-datetime-extract">below</link>
</entry>
<entry>extract(hour from timestamp '2001-02-16 20:38:40')</entry>
@@ -2177,10 +2175,9 @@ reasonable at all for that matter.
</row>
<row>
- <entry>extract(identifier from interval)</entry>
+ <entry>extract(<parameter>field</parameter> from interval)</entry>
<entry>double precision</entry>
- <entry>
- extract subfield from interval value; see also <link
+ <entry>Get subfield; see also <link
linkend="functions-datetime-extract">below</link>
</entry>
<entry>extract(month from interval '2 years 3 months')</entry>
@@ -2190,7 +2187,7 @@ reasonable at all for that matter.
<row>
<entry>isfinite(timestamp)</entry>
<entry>boolean</entry>
- <entry>Returns true if the time stamp is finite (neither invalid nor infinity)</entry>
+ <entry>Test for finite time stamp (neither invalid nor infinity)</entry>
<entry>isfinite(timestamp '2001-02-16 21:28:30')</entry>
<entry>true</entry>
</row>
@@ -2198,7 +2195,7 @@ reasonable at all for that matter.
<row>
<entry>isfinite(interval)</entry>
<entry>boolean</entry>
- <entry>Returns true if the interval is finite in length</entry>
+ <entry>Test for finite interval</entry>
<entry>isfinite(interval '4 hours')</entry>
<entry>true</entry>
</row>
@@ -2206,8 +2203,7 @@ reasonable at all for that matter.
<row>
<entry>now()</entry>
<entry>timestamp</entry>
- <entry>
- returns current date and time (equivalent to
+ <entry>Current date and time (equivalent to
<function>current_timestamp</function>); see also <link
linkend="functions-datetime-current">below</link>
</entry>
@@ -2218,8 +2214,7 @@ reasonable at all for that matter.
<row>
<entry>timeofday()</entry>
<entry>text</entry>
- <entry>
- returns high-precision date and time; see also <link
+ <entry>High-precision date and time; see also <link
linkend="functions-datetime-current">below</link>
</entry>
<entry>timeofday()</entry>
@@ -2229,7 +2224,7 @@ reasonable at all for that matter.
<row>
<entry>timestamp(date)</entry>
<entry>timestamp</entry>
- <entry>convert date to timestamp</entry>
+ <entry>Date to timestamp</entry>
<entry>timestamp(date '2000-12-25')</entry>
<entry>2000-12-25 00:00:00</entry>
</row>
@@ -2237,7 +2232,7 @@ reasonable at all for that matter.
<row>
<entry>timestamp(date, time)</entry>
<entry>timestamp</entry>
- <entry>combine date and time into a timestamp</entry>
+ <entry>Date and time to a timestamp</entry>
<entry>timestamp(date '1998-02-24',time '23:07')</entry>
<entry>1998-02-24 23:07:00</entry>
</row>
@@ -2260,8 +2255,8 @@ EXTRACT (<replaceable>field</replaceable> FROM <replaceable>source</replaceable>
evaluates to type <type>timestamp</type> or <type>interval</type>.
(Expressions of type <type>date</type> or <type>time</type> will
be cast to <type>timestamp</type> and can therefore be used as
- well.) <replaceable>field</replaceable> is an identifier (not a
- string!) that selects what field to extract from the source value.
+ well.) <replaceable>field</replaceable> is an identifier or
+ string that selects what field to extract from the source value.
The <function>extract</function> function returns values of type
<type>double precision</type>.
The following are valid values:
@@ -2283,7 +2278,9 @@ SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40');
</informalexample>
<para>
- Note that this is not really the century that the date is in.
+ Note that the result for the century field is simply the year field
+ divided by 100, and not the conventional definition which puts most
+ years in the 1900's in the twentieth century.
</para>
</listitem>
</varlistentry>
@@ -2422,7 +2419,9 @@ SELECT EXTRACT(MILLENNIUM FROM TIMESTAMP '2001-02-16 20:38:40');
</informalexample>
<para>
- Note that this is not really the millennium that the date is in.
+ Note that the result for the millennium field is simply the year field
+ divided by 1000, and not the conventional definition which puts
+ years in the 1900's in the second millennium.
</para>
</listitem>
</varlistentry>
@@ -2577,8 +2576,8 @@ tz_minute
<anchor id="functions-datetime-datepart">
<para>
- The <function>date_part</function> function is the traditional
- <productname>Postgres</productname> equivalent to the
+ The <function>date_part</function> function is modeled on the traditional
+ <productname>Ingres</productname> equivalent to the
<acronym>SQL</acronym>-function <function>extract</function>:
<synopsis>
date_part('<replaceable>field</replaceable>', <replaceable>source</replaceable>)
@@ -3459,7 +3458,7 @@ SELECT NULLIF(value, '(none)') ...
<title>Miscellaneous Functions</>
<tgroup cols="3">
<thead>
- <row><entry>Name</> <entry>Return type</> <entry>Description</></row>
+ <row><entry>Name</> <entry>Return Type</> <entry>Description</></row>
</thead>
<tbody>
diff --git a/doc/src/sgml/geqo.sgml b/doc/src/sgml/geqo.sgml
index 19ecca700e0..969c1820b35 100644
--- a/doc/src/sgml/geqo.sgml
+++ b/doc/src/sgml/geqo.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/geqo.sgml,v 1.15 2000/12/22 21:51:57 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/geqo.sgml,v 1.16 2001/04/20 15:52:33 thomas Exp $
Genetic Optimizer
-->
@@ -28,7 +28,7 @@ Genetic Optimizer
<date>1997-10-02</date>
</docinfo>
- <title>Genetic Query Optimization in Database Systems</title>
+ <title>Genetic Query Optimization</title>
<para>
<note>
diff --git a/doc/src/sgml/libpgeasy.sgml b/doc/src/sgml/libpgeasy.sgml
index a8dac2a67d5..e7195ae4765 100644
--- a/doc/src/sgml/libpgeasy.sgml
+++ b/doc/src/sgml/libpgeasy.sgml
@@ -1,9 +1,9 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpgeasy.sgml,v 2.4 2000/12/22 21:51:58 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/Attic/libpgeasy.sgml,v 2.5 2001/04/20 15:52:33 thomas Exp $
-->
<chapter id="pgeasy-chapter">
- <title id="pgeasy">libpgeasy - Simplified C Binding Library</title>
+ <title id="pgeasy">libpgeasy - Simplified C Library</title>
<note>
<title>Author</title>
diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml
index d0e020b982c..ee7778807a3 100644
--- a/doc/src/sgml/mvcc.sgml
+++ b/doc/src/sgml/mvcc.sgml
@@ -1,5 +1,5 @@
<!--
-$Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.12 2001/03/28 20:46:34 tgl Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.13 2001/04/20 15:52:33 thomas Exp $
-->
<chapter id="mvcc">
@@ -101,6 +101,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.12 2001/03/28 20:46:34 tgl Ex
<thead>
<row>
<entry>
+ Isolation Level
</entry>
<entry>
Dirty Read
diff --git a/doc/src/sgml/user-manag.sgml b/doc/src/sgml/user-manag.sgml
index c1830560b0d..12b4bfe9a50 100644
--- a/doc/src/sgml/user-manag.sgml
+++ b/doc/src/sgml/user-manag.sgml
@@ -1,5 +1,5 @@
<Chapter id="user-manag">
- <title>Database User and Permission Management</title>
+ <title>Database Users and Permissions</title>
<para>
Managing database users and their privileges is in concept similar