Testing a Value in a Search Condition

From InterBase
Jump to: navigation, search

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.

Advance To: