> > 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

Reply via email to