aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlvaro Herrera <alvherre@alvh.no-ip.org>2008-04-27 04:33:27 +0000
committerAlvaro Herrera <alvherre@alvh.no-ip.org>2008-04-27 04:33:27 +0000
commita1d479f518394a68f47e3dd64ac5c4626da6c534 (patch)
tree89c30155d810d63193002db930a9a2eee43e6e61
parentea0382e3706ab25935c733fd452d828832e4675f (diff)
downloadpostgresql-a1d479f518394a68f47e3dd64ac5c4626da6c534.tar.gz
postgresql-a1d479f518394a68f47e3dd64ac5c4626da6c534.zip
Add SGML ID attributes to the arrays subsections, and a few index entries for
them.
-rw-r--r--doc/src/sgml/array.sgml39
1 files changed, 32 insertions, 7 deletions
diff --git a/doc/src/sgml/array.sgml b/doc/src/sgml/array.sgml
index bf81c29aaf1..87df7e556a2 100644
--- a/doc/src/sgml/array.sgml
+++ b/doc/src/sgml/array.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.64 2008/03/26 16:34:47 tgl Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.65 2008/04/27 04:33:27 alvherre Exp $ -->
<sect1 id="arrays">
<title>Arrays</title>
@@ -15,9 +15,14 @@
Arrays of domains are not yet supported.
</para>
- <sect2>
+ <sect2 id="arrays-declaration">
<title>Declaration of Array Types</title>
+ <indexterm>
+ <primary>array</primary>
+ <secondary>declaration</secondary>
+ </indexterm>
+
<para>
To illustrate the use of array types, we create this table:
<programlisting>
@@ -77,7 +82,7 @@ CREATE TABLE tictactoe (
</para>
</sect2>
- <sect2>
+ <sect2 id="arrays-input">
<title>Array Value Input</title>
<indexterm>
@@ -189,9 +194,14 @@ ERROR: multidimensional arrays must have array expressions with matching dimens
</para>
</sect2>
- <sect2>
+ <sect2 id="arrays-accessing">
<title>Accessing Arrays</title>
+ <indexterm>
+ <primary>array</primary>
+ <secondary>accessing</secondary>
+ </indexterm>
+
<para>
Now, we can run some queries on the table.
First, we show how to access a single element of an array at a time.
@@ -315,9 +325,14 @@ SELECT array_upper(schedule, 1) FROM sal_emp WHERE name = 'Carol';
</para>
</sect2>
- <sect2>
+ <sect2 id="arrays-modifying">
<title>Modifying Arrays</title>
+ <indexterm>
+ <primary>array</primary>
+ <secondary>modifying</secondary>
+ </indexterm>
+
<para>
An array value can be replaced completely:
@@ -489,9 +504,14 @@ SELECT array_cat(ARRAY[5,6], ARRAY[[1,2],[3,4]]);
</para>
</sect2>
- <sect2>
+ <sect2 id="arrays-searching">
<title>Searching in Arrays</title>
+ <indexterm>
+ <primary>array</primary>
+ <secondary>searching</secondary>
+ </indexterm>
+
<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.
@@ -533,9 +553,14 @@ SELECT * FROM sal_emp WHERE 10000 = ALL (pay_by_quarter);
</tip>
</sect2>
- <sect2>
+ <sect2 id="arrays-io">
<title>Array Input and Output Syntax</title>
+ <indexterm>
+ <primary>array</primary>
+ <secondary>I/O</secondary>
+ </indexterm>
+
<para>
The external text representation of an array value consists of items that
are interpreted according to the I/O conversion rules for the array's