diff options
author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2008-04-27 04:33:27 +0000 |
---|---|---|
committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2008-04-27 04:33:27 +0000 |
commit | a1d479f518394a68f47e3dd64ac5c4626da6c534 (patch) | |
tree | 89c30155d810d63193002db930a9a2eee43e6e61 | |
parent | ea0382e3706ab25935c733fd452d828832e4675f (diff) | |
download | postgresql-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.sgml | 39 |
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 |