| Operation | Description |
|---|---|
|
column_name "column_name" |
value of field column_name |
| 'string' | literal string value |
| number | number |
| NULL | null value |
| a OR b | a or b are true. |
| a AND b | a and b are true. |
| NOT a | inverted boolean value of a |
| a IS NULL | a has no value |
| a IS NOT NULL | a has a value |
| a IN ( value[, value...] ) | a is one of the listed values |
| a NOT IN ( value[, value...] ) | a is not one of the listed values |
| a = b | a and b are equal |
|
a != b a <> b |
a and b are not equal |
| a <= b | a is less or equal b |
| a >= b | a is greater or equal b |
| a > b | a is greater than b |
| a < b | a is less than b |
| a ~ b | a matches regular expression b |
| a LIKE b | a is like b |
| a ILIKE b | a is like b (case insensitive) |
| sqrt(a) | square root |
| sin(a) | sinus of a |
| cos(a) | cosinus of b |
| tan(a) | tangens of a |
| asin(a) | arcussinus of a |
| acos(a) | arcuscosinus of a |
| atan(a) | arcustangens of a |
| to int(a) | convert string a to integer |
| to real(a) | convert string a to real |
| to string(a) | convert number a to string |
| lower(a) | convert string a to lower case |
| upper(a) | convert string a to upper case |
| length(a) | length of string a |
| atan2(y,x) | arcustangens of y/x using the signs of the two arguments to determine the quadrant of the result. |
| replace(a,replacethis,withthat) | replace replacethis with withthat in string a |
| substr(a,from,len) | len characters of string a starting from from (first character index is 1) |
| a || b | concatenate strings a and b |
| $rownum | number current row |
| $area | area of polygon |
| $perimeter | perimeter of polygon |
| $length | area of line |
| $id | feature id |
| $x | x coordinate of point |
| $y | y coordinate of point |
| a ^ b | a raised to the power of b |
| a * b | a multiplied by b |
| a / b | a divided by b |
| a + b | a plus b |
| a - b | a minus b |
| +a | positive sign |
| -a | negative value of a |