Miscellany

INSERT INTO table (1, 2, 3, 4, 5, 6)SELECT   CASE WHEN (              SELECT * FROM table              WHERE  2  = 'foo'              AND    3  = 'bar'              AND    5                 BETWEEN                   NOW() - INTERVAL '5 minutes'                 AND                   NOW()              ) > 5       THEN 'value1'       ELSE 'othervalue' END, 'value2', 'value3','value4', 'value5', 'value6'