Queries that include the NOT keyword

You cannot use the NOT keyword before the etx_contains() operator in the WHERE clause of a query. You must rewrite the query so that it does not use the NOT keyword.

For example, the following query returns an error: 
SELECT id FROM recipes 
    WHERE NOT etx_contains (ingredients, 'eggs');
Consider splitting the query into the following two queries: 
SELECT id FROM recipes 
    WHERE etx_contains(ingredients, 'eggs') INTO TEMP t1;
SELECT id FROM recipes 
    WHERE id NOT IN (SELECT id FROM t1);