Skip to content

Commit a1d479f

Browse files
committed
Add SGML ID attributes to the arrays subsections, and a few index entries for
them.
1 parent ea0382e commit a1d479f

File tree

1 file changed

+32
-7
lines changed

1 file changed

+32
-7
lines changed

doc/src/sgml/array.sgml

Lines changed: 32 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.64 2008/03/26 16:34:47 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/array.sgml,v 1.65 2008/04/27 04:33:27 alvherre Exp $ -->
22

33
<sect1 id="arrays">
44
<title>Arrays</title>
@@ -15,9 +15,14 @@
1515
Arrays of domains are not yet supported.
1616
</para>
1717

18-
<sect2>
18+
<sect2 id="arrays-declaration">
1919
<title>Declaration of Array Types</title>
2020

21+
<indexterm>
22+
<primary>array</primary>
23+
<secondary>declaration</secondary>
24+
</indexterm>
25+
2126
<para>
2227
To illustrate the use of array types, we create this table:
2328
<programlisting>
@@ -77,7 +82,7 @@ CREATE TABLE tictactoe (
7782
</para>
7883
</sect2>
7984

80-
<sect2>
85+
<sect2 id="arrays-input">
8186
<title>Array Value Input</title>
8287

8388
<indexterm>
@@ -189,9 +194,14 @@ ERROR: multidimensional arrays must have array expressions with matching dimens
189194
</para>
190195
</sect2>
191196

192-
<sect2>
197+
<sect2 id="arrays-accessing">
193198
<title>Accessing Arrays</title>
194199

200+
<indexterm>
201+
<primary>array</primary>
202+
<secondary>accessing</secondary>
203+
</indexterm>
204+
195205
<para>
196206
Now, we can run some queries on the table.
197207
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';
315325
</para>
316326
</sect2>
317327

318-
<sect2>
328+
<sect2 id="arrays-modifying">
319329
<title>Modifying Arrays</title>
320330

331+
<indexterm>
332+
<primary>array</primary>
333+
<secondary>modifying</secondary>
334+
</indexterm>
335+
321336
<para>
322337
An array value can be replaced completely:
323338

@@ -489,9 +504,14 @@ SELECT array_cat(ARRAY[5,6], ARRAY[[1,2],[3,4]]);
489504
</para>
490505
</sect2>
491506

492-
<sect2>
507+
<sect2 id="arrays-searching">
493508
<title>Searching in Arrays</title>
494509

510+
<indexterm>
511+
<primary>array</primary>
512+
<secondary>searching</secondary>
513+
</indexterm>
514+
495515
<para>
496516
To search for a value in an array, you must check each value of the
497517
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);
533553
</tip>
534554
</sect2>
535555

536-
<sect2>
556+
<sect2 id="arrays-io">
537557
<title>Array Input and Output Syntax</title>
538558

559+
<indexterm>
560+
<primary>array</primary>
561+
<secondary>I/O</secondary>
562+
</indexterm>
563+
539564
<para>
540565
The external text representation of an array value consists of items that
541566
are interpreted according to the I/O conversion rules for the array's

0 commit comments

Comments
 (0)