On 06/21/2013 09:45 AM, Pavlo Lavrenenko wrote: > As you can see recent message number differs. What is the correct number > of recent messages? > Should they be counted according to recent_flag value only?
It should. The query is producing incorrect results if both the seen and recent flags are set.... -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 ________________________________________________________________ _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev