Re: SQL on partitioned table

[Phil Hildebrand]

I dont' think it is...

you'd have to just do the full select from partition with the same restriction as the partition istelf:

select * from my_part_table where my_part_column = '2008-10-30';

that should only look at the one partition if that partition contains only rows with '2008-10-30'

What's the end goal? You might be able to use the information_schema partitions table if you are trying to do some automated partition switching or loading...