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