Skip to content

Latest commit

 

History

History
32 lines (24 loc) · 712 Bytes

arrayremoveint.md

File metadata and controls

32 lines (24 loc) · 712 Bytes
Raw
description
This section contains reference documentation for the arrayRemoveInt function.

arrayRemoveInt

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