Accessing Arrays

Go Up to Using Arrays

InterBase can perform operations on an entire array, effectively treating it as a single element, or it can operate on an array slice, a subset of array elements. An array slice can consist of a single element, or a set of many contiguous elements.

InterBase supports the following data manipulation operations on arrays:

• Selecting data from an array
• Inserting data into an array
• Updating data in an array slice
• Selecting data from an array slice
• Evaluating an array element in a search condition

A user-defined function (UDF) can only reference a single array element.

The following array operations are not supported:

• Referencing array dimensions dynamically in DSQL
• Inserting data into an array slice
• Setting individual array elements to NULL
• Using the aggregate functions, MIN(), MAX(), SUM(), AVG(), and COUNT() with arrays
• Referencing arrays in the GROUP BY clause of a SELECT
• Creating views that select from array slices

Topics

• Selecting Data from an Array
• Inserting Data into an Array
• Selecting from an Array Slice
• Updating Data in an Array Slice
• Testing a Value in a Search Condition
• Using Host Variables in Array Subscripts
• Using Arithmetic Expressions with Arrays