On 8/1/05, Paolo Cravero as2594 <[EMAIL PROTECTED]> wrote: > Mark Martinec wrote: > > Dobar Dan Mark > > > I think that instead of asking for: > > SELECT count(*) FROM quarantine; > > (which gives the number of records in the database) > > > > it would be more informative to ask for: > > SELECT count(*) FROM quarantine WHERE chunk_ind = 1; > > > > to get the number of quarantined messages, regardless of their size, > > which may span multiple 16 kB chunks. > > Those two queries return different results. Did you mean "chunk_ind >= > 1", perhaps? In that case the count corresponds. >
No. It is "WHERE chunk_ind = 1". Otherwise you may count some quarantined messages multiple times. Do a "SELECT * FROM quarantine" for the mail_id of a message larger than 16kB. You will understand then. Sam ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/