Re: Dynamic Partial Index

On Thu, 2006-08-17 at 20:50 +0300, gustavo halperin wrote:
> I'm interesting in a partial index for a rows that aren't older than 6
> mounts, something like the sentence below:
>
--------------------------------------------------------------------------------------------------------------------------------------------------
>     /CREATE INDEX name_for_the_index ON table (the_column_of_type_date)
>
>     WHERE ( the_column_of_type_date > (current_date - interval '6
> month')::date );/
>
--------------------------------------------------------------------------------------------------------------------------------------------------
> But this is not posible, I receive the next error:
>
--------------------------------------------------------------------------------------------------------------------------------------------------
>    ERROR:  functions in index predicate must be marked IMMUTABLE
>
--------------------------------------------------------------------------------------------------------------------------------------------------
> So, what is the best solution for my problem?

Create an index on the table, and then periodically move records into a
separate archive table.

Regards,
    Jeff Davis