From a1d479f518394a68f47e3dd64ac5c4626da6c534 Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Sun, 27 Apr 2008 04:33:27 +0000 Subject: [PATCH] Add SGML ID attributes to the arrays subsections, and a few index entries for them. --- doc/src/sgml/array.sgml | 39 ++++++++++++++++++++++++++++++++------- 1 file changed, 32 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/array.sgml b/doc/src/sgml/array.sgml index bf81c29aaf..87df7e556a 100644 --- a/doc/src/sgml/array.sgml +++ b/doc/src/sgml/array.sgml @@ -1,4 +1,4 @@ - + Arrays @@ -15,9 +15,14 @@ Arrays of domains are not yet supported. - + Declaration of Array Types + + array + declaration + + To illustrate the use of array types, we create this table: @@ -77,7 +82,7 @@ CREATE TABLE tictactoe ( - + Array Value Input @@ -189,9 +194,14 @@ ERROR: multidimensional arrays must have array expressions with matching dimens - + Accessing Arrays + + array + accessing + + 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'; - + Modifying Arrays + + array + modifying + + An array value can be replaced completely: @@ -489,9 +504,14 @@ SELECT array_cat(ARRAY[5,6], ARRAY[[1,2],[3,4]]); - + Searching in Arrays + + array + searching + + 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); - + Array Input and Output Syntax + + array + I/O + + 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 -- 2.40.0