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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
