Re: [SQL] Partitioning by letter question

2010-01-29 Thread Scott Marlowe
On Fri, Jan 29, 2010 at 3:24 PM, John Lister wrote: > Hi, I was wondering if this was possible. I'm trying to partition a table, > which is straightforward enough thanks to the great documentation, but i > have a question: > > If I partition using something like a product_id for example and have c

[SQL] Partitioning by letter question

2010-01-29 Thread John Lister
Hi, I was wondering if this was possible. I'm trying to partition a table, which is straightforward enough thanks to the great documentation, but i have a question: If I partition using something like a product_id for example and have check constraints such as (id>=1000 and id<2000) then every