Filter Expressions - Number

Example

a.population:             ### SQL interpretation ###
- 'any'                   #'any' = 'any'
- '100'                   #a.population = 100
- '105, 110, 115'         #a.population IN (105, 110, 115)
- '> 100'                 #a.population >  100
- '>= 100'                #a.population >= 100
- '< 100'                 #a.population <  100
- '<= 100'                #a.population <= 100
- '[100 , 200]'           #(a.population >= 100) AND (a.population <= 200)
- '[100 , 200)'           #(a.population >= 100) AND (a.population <  200)
- '(100 , 200]'           #(a.population >  100) AND (a.population <= 200)
- '(100 , 200)'           #(a.population >  100) AND (a.population <  200)
- 'null'                  #a.population IS NULL
- 'not 100'               #NOT (a.population = 100)
- 'not 105, 110, 115'     #NOT (a.population IN (105, 110, 115))
- 'not [100 , 200]'       #NOT ((a.population >= 100) AND (a.population <= 200))
- 'not [100 , 200)'       #NOT ((a.population >= 100) AND (a.population <  200))
- 'not (100 , 200]'       #NOT ((a.population >  100) AND (a.population <= 200))
- 'not (100 , 200)'       #NOT ((a.population >  100) AND (a.population <  200))
- 'not null'              #NOT (a.population IS NULL)

Description

Expression	Description
any	is any value (same as no filter)
100	is exactly 100
105, 110, 115	is one of the values 105, 110 or 115 exactly
> 100	any value greater than 100
>= 100	any value greater than or equal to 100
< 100	any value less than 100
<= 100	any value less than or equal to 100
[100 , 200]	interpreted as 100 <= x <= 200 where the endpoints are included
[100 , 200)	interpreted as 100 <= x < 200 where 100 is included, but 200 is not included
(100 , 200]	interpreted as 100 < x <= 200 where 100 is not included, but 200 is included
(100 , 200)	interpreted as 100 < x < 200 where the endpoints are NOT included
null	has no data
not null	has data