Re: multi column range partitioning

cosmini_at_yahoo.com (cosmin ioan) wrote in message news:<80fb0771.0303290518.6e574069_at_posting.google.com>...
> thanks much Jusung,
> I think I took the 'less than' literally but instead it looks like the
> syntax should read 'less than or equal to'. In that case, your
> explanation makes perfect sense.
>
> thanks again,
> Cosmin
>

Actually, less than does mean 'less than'. It just that it is not very apparent when you have multiple column key. If you have partitions like:

p1 values less than (3,4,10)
p2 values less than max

then (3,4,10) will go to partition p2.

• Jusung Yang