*** ./doc/src/sgml/array.sgml.orig	Mon Dec  4 01:32:07 2000
--- ./doc/src/sgml/array.sgml	Mon Dec  4 01:38:12 2000
***************
*** 153,156 ****
--- 153,194 ----
       unspecified length.
  </Para>
  
+ <Para>
+  To search for a value in an array, you must check each value of
+  the array. This can be done by hand (if you know the size of the array):
+ 
+  <ProgramListing>
+ SELECT * FROM sal_emp WHERE pay_by_quarter[1] = 10000 OR
+                             pay_by_quarter[2] = 10000 OR
+                             pay_by_quarter[3] = 10000 OR
+                             pay_by_quarter[4] = 10000;
+  </ProgramListing>
+ 
+  However, this quickly becomes tedious for large arrays, and is not helpful
+  if the size of the array is unknown. Although it is not part of the primary
+  PostgreSQL distribution, in the contributions directory, there is an extension to
+  PostgreSQL that defines new functions and operators for iterating over array
+  values. Using this, the above query could be:
+ 
+  <ProgramListing>
+ SELECT * FROM sal_emp WHERE pay_by_quarter[1:4] *= 10000;
+  </ProgramListing>
+ 
+  To search the entire array (not just specified columns), you could use:
+ 
+  <ProgramListing>
+ SELECT * FROM sal_emp WHERE pay_by_quarter *= 10000;
+  </ProgramListing>
+ 
+ In addition, you could find rows where the array had all values equal to 
+ 10,000 with:
+ 
+ <ProgramListing>
+ SELECT * FROM sal_emp WHERE pay_by_quarter **= 10000;
+ </ProgramListing>
+ 
+  To install this optional module, look in the <filename>/contrib/array</filename> directory
+  of the PostgreSQL source installation.
+ </Para>
+ 
  </Chapter>
*** ./doc/src/sgml/datatype.sgml.orig	Mon Dec  4 01:28:32 2000
--- ./doc/src/sgml/datatype.sgml	Mon Dec  4 01:31:51 2000
***************
*** 138,143 ****
--- 138,148 ----
         <entry>exact numeric with selectable precision</entry>
        </row>
        <row>
+        <entry>oid</entry>
+        <entry></entry>
+        <entry>object id (unique identifier for every PostgreSQL object</entry>
+       </row>
+       <row>
         <entry>path</entry>
         <entry></entry>
         <entry>open and closed geometric path in 2D plane</entry>
***************
*** 155,161 ****
        <row>
         <entry>serial</entry>
         <entry></entry>
!        <entry>unique id for indexing and cross-reference</entry>
        </row>
        <row>
         <entry>text</entry>
--- 160,166 ----
        <row>
         <entry>serial</entry>
         <entry></entry>
!        <entry>unique integer id for indexing and cross-reference</entry>
        </row>
        <row>
         <entry>text</entry>
***************
*** 1383,1389 ****
      <acronym>NULL</acronym> is an
      effective substitute. <type>bool</type> can be used in any boolean expression, 
      and boolean expressions
!     always evaluate to a result compatible with this type.</para>
  
     <para>
      <type>bool</type> uses 1 byte of storage.
--- 1388,1402 ----
      <acronym>NULL</acronym> is an
      effective substitute. <type>bool</type> can be used in any boolean expression, 
      and boolean expressions
!     always evaluate to a result compatible with this type.
!    </para>
! 
!    <para>
!     Note that <type>bool</type> values do not have a numeric equivalent. 
!     PostgreSQL will reject, for example, a boolean value input as an number
!     (unless entered as a string, '1' for true, and '0' for false). 
!     A <type>bool</type> value cannot be CAST into a numeric values.
!    </para>
  
     <para>
      <type>bool</type> uses 1 byte of storage.
*** ./doc/src/sgml/func.sgml.orig	Mon Dec  4 01:20:40 2000
--- ./doc/src/sgml/func.sgml	Mon Dec  4 01:23:59 2000
***************
*** 88,93 ****
--- 88,103 ----
  	<entry>abs(-17.4)</entry>
         </row>
         <row>
+         <entry>ceil(numeric)</entry>
+         <entry>numeric</entry>
+         <entry>smallest integer >= value</entry>
+        </row>
+        <row>
+         <entry>floor(numeric)</entry>
+         <entry>numeric</entry>
+         <entry>largest integer <= value</entry>
+        </row>
+        <row>
  	<entry>degrees(float8)</entry>
  	<entry>float8</entry>
  	<entry>radians to degrees</entry>
***************
*** 110,115 ****
--- 120,131 ----
  	<entry>float8</entry>
  	<entry>base 10 logarithm</entry>
  	<entry>log(2.0)</entry>
+        </row>
+         <row>
+         <entry>log(numeric, numeric)</entry>
+         <entry>numeric</entry>
+         <entry>logarithm base n of m</entry>
+         <entry>log(5.0, 2.0)</entry>
         </row>
         <row>
  	<entry>pi()</entry>
*** ./doc/src/sgml/oper.sgml.orig	Mon Dec  4 01:17:45 2000
--- ./doc/src/sgml/oper.sgml	Mon Dec  4 01:19:27 2000
***************
*** 25,39 ****
     To view all variations of the "<literal>||</literal>" string concatenation operator, 
     try
     <ProgramListing>
!     SELECT oprleft, oprright, oprresult, oprcode
!     FROM pg_operator WHERE oprname = '||';
! 
! oprleft|oprright|oprresult|oprcode
! -------+--------+---------+-------
!      25|      25|       25|textcat
!    1042|    1042|     1042|textcat
!    1043|    1043|     1043|textcat
! (3 rows)
     </ProgramListing>
    </Para>
  
--- 25,39 ----
     To view all variations of the "<literal>||</literal>" string concatenation operator, 
     try
     <ProgramListing>
!     \do ||
!                               List of operators
!  Op |     Left arg      |     Right arg     | Result |      Description
! ----+-------------------+-------------------+--------+-----------------------
!  || | bit               | bit               | bit    | bitwise concatenation
!  || | character         | character         | text   | concatenate
!  || | character varying | character varying | text   | concatenate
!  || | text              | text              | text   | concatenate
! (4 rows)
     </ProgramListing>
    </Para>
  
*** ./doc/src/sgml/syntax.sgml.orig	Mon Dec  4 01:08:21 2000
--- ./doc/src/sgml/syntax.sgml	Mon Dec  4 01:15:57 2000
***************
*** 435,440 ****
--- 435,446 ----
       (e.g. <literal>'\<replaceable>tab</replaceable>'</literal>).
      </para>
  
+     <para>
+      Backslashes may also be used to insert newlines (\n), tabs (\t),
+      linefeeds (\r), or any arbitrary character (\xxx, where xxx is the character code
+      in octal).
+     </para>
+ 
     </sect2>
  
     <sect2>