Re: type cast in index - Mailing list pgsql-general

>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

        If your time_stamp_creacion is a timestamp with time zone I
believe that the cast is not immutable.