> > ALTER TABLE quarantine PARTITION BY LIST (partition_tag) ( > > PARTITION p0 VALUES IN (1,5,9,13,17,21,25,29,33,37,41,45,49), > > PARTITION p1 VALUES IN (2,6,10,14,18,22,26,30,34,38,42,46,50), > > PARTITION p2 VALUES IN (3,7,11,15,19,23,27,31,35,39,43,47), > > PARTITION p3 VALUES IN (4,8,12,16,20,24,28,32,36,40,44,48,52));
Not to forget that some years have 53 weeks (1..53). Mark ------------------------------------------------------------------------------ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org