Testing a Value in a Search Condition
From InterBase
Go Up to Accessing Arrays
A single array element’s value can be evaluated in the search condition of a WHERE clause. For example,
EXEC SQL DECLARE TC2 CURSOR FOR SELECT CHAR_ARR[1], INT_ARR[1:2,1:3] FROM TABLE1 WHERE SMALLINT_ARR[1,1,1] = 111;
Important:
You cannot evaluate multi-element array slices.
You cannot evaluate multi-element array slices.