It is really a problem. I came across it on Informix server.To make it worth
it seems to me that when you try to use function
on partition column you loose all advantages of partitions. My solution is to
create new column to hold day's number and trigger to update it.
> Hello Friends,
>
> i would create a partionied table, and the table should fall into 7
> partitions, each for a day of the week:
>
> partition 1: monday
> ......
> partition 7: sunday
>
> I think, thats not possible with a date-column, because
>
> ...
> PARTITION BY RANGE (to_char(date_column,'D'))
> ...
>
> is not possible.
>
> Have somebody an idea, how i can moke this partition with a date-column???
>
> Thanks
>
> M. Rabe
> Stuttgart, Germany
Received on Wed Aug 11 1999 - 02:08:21 CDT
