Create a range partition to simulate a list partition
I'd like to create a table with a range partition that will contain only one value for the partitioned column. The reason I need to do this is that the table contains a spatial column. Currently in 9.2 you can't create local spatial indexes on List or Hash partitions. The table needs to be partitioned by a market, i.e New York City, Albany and so forth.
I know how to create a range partition if there will be multiple values for the column but how would this be done for a single value?