no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+======Spam Filter Rules: DBDeleteTime======
+^Statement  |DBDeleteTime |
+^Version  |6.16+ |
+^Purpose  |Deletes records from the spam filter database based on their last update time |
+The **DBDeleteTime** statement requires a component name, comparator and time value, in the format
+  DBDeleteTime <component name> <comparator> <timevalue>
+  * The comparator is < = > <= >= or <> (< is the most useful)
+  * <timevalue> is something like "5 seconds" or "10 minutes" or "3 weeks" (see PostgreSQL Interval Input - [[http://www.postgresql.org/docs/9.1/static/datatype-datetime.html#DATATYPE-INTERVAL-INPUT]]
+Example
+  DBDeleteTime subject < "3 months"
+This will delete all records for the 'subject' component which were last updated earlier than 3 months ago.
+The SQL expression is created as 'updatetime <comparator> now() - <timevalue>', so the above statement's query string becomes ''where updatetime < now() - '3 months' ''

PSCS Wiki