======Spamfilter database comparators====== Several Spamfilter DB statements allow comparators which are listed below If the value specified in the statement is numeric: * = or == compare numeric values for equality * <> or != compare numeric values for inequality * <, >, <=, >= do standard numeric comparisons * If the value specified in the statement is non-numeric: * = or == compare string values for equality using plain ASCII comparisons * <> or != compare string values for inequality using plain ASCII comparisons * <, >, <=, >= do string comparisons using plain ASCII comparisons * A '*' after each of the above comparators makes them case insensitive (eg **==* **) Whether or not the value specified in the statement is numeric: * **eq** compares string values for equality using plain ASCII comparisons * **ne** compares string values for inequality using plain ASCII comparisons * **lt** does a 'less than' string comparison using plain ASCII comparisons * **le** does a 'less than or equals' string comparison using plain ASCII comparisons * **gt** does a 'greater than' string comparison using plain ASCII comparisons * **ge** does a 'greater than or equals' string comparison using plain ASCII comparisons * An 'i' after each of the above comparators makes them case insensitive (eg **nei**) * ~ does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|POSIX regular expression]] match comparison * !~ does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|POSIX regular expression]] not-match comparison * ~* does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|case insensitive POSIX regular expression]] match comparison * !~* does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCTIONS-POSIX-REGEXP|case insensitive POSIX regular expression]] not-match comparison * LIKE does an SQL 'LIKE' comparison * ILIKE does a case insensitive SQL 'LIKE' comparison