Accessing Arrays
From InterBase
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()
, andCOUNT()
with arrays - Referencing arrays in the
GROUP BY
clause of aSELECT
- 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