Martin A. Brooks wrote: > Ian P. Christian wrote: >> However, this will obviously return nothing if the host has never mailed >> before, and the 'Spam total' reports as NULL >> > > I'm not sure about sqlite but postgres has a function called > "COALESCE"[0] which can be used to remove nulls from results. Perhaps > sqlite has something similar. > >
For the record, this does work in sqlite. Must admit, I'm really very impressed with the sqlite feature set - in my experience it does struggle a lot under load, but that's a discussion for elsewhere I'm sure :) Thanks Martin - I guess this is the best way to handle the problem Regards, -- Ian P. Christian ~ http://pookey.co.uk -- ## List details at http://www.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://www.exim.org/eximwiki/
