Hello, > BTW: I'm sure this is over simplistic, but is there a reason that we can't > just use triggers? I know postgres supports them, and the also have built > in regex, it would seem very easy to just add a trigger that says, when a > message inserted into the messages table, update the folder to X if header Y > is equal to Z. What am I missing here?
Yes, that'd be possible, but it's not nearly as flexible (what if the action of one of your filters would be to forward the message to an off-site user?), and not at all portable. Doing the sorting at delivery time is the best way (that I can think of, at least). -- Jesse Norell jesse (at) kci.net