type cast in index - Mailing list pgsql-general

From Linos
Subject type cast in index
Date
Msg-id 4A2E8BC5.8080902@linos.es
Whole thread Raw
Responses Re: type cast in index
Re: type cast in index
List pgsql-general
Hello,
    i have reading in the mailing list any messages where different people use this
format to establish a functional index in a column using a type cast.

CREATE INDEX fecha_creacion_ordtrab ON orden_trabajo_cabecera USING btree
((time_stamp_creacion::date));

but in my postgresql 8.3 version i get this error:

ERROR:  functions in index expression must be marked IMMUTABLE

I have tried with the typical CAST too but i get the same error, the column in
the table is:

                Column          |           Type                        |
Modifiers
time_stamp_creacion     | timestamp with time zone | default now()

What can be the problem? Thanks.

Regards,
Miguel Angel.

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: postgres getting slow under heavy load though autivacuum is enabled
Next
From: "Octavio Alvarez"
Date:
Subject: Re: limit table to one row