arrayRemoveInt

This section contains reference documentation for the arrayRemoveInt function.

Removes value from array of ints.

Signature

arrayRemoveInt('colName', value)

Usage Examples

These examples are based on the Hybrid Quick Start.

select DivAirportIDs, 
       arrayRemoveInt(DivAirportIDs, 12892) AS value
from airlineStats 
WHERE arraylength(DivAirportIDs) >= 2
AND arrayContainsInt(DivAirportIDs, 12892) = 1
limit 5

DivAirportIDs	value
13891,12892	13891
13198,12892	13198
11066,12892	11066
13198,12892	13198
13891,12892	13891