Re: type cast in index

Yes it seems you have reason Chris, i have been using 'timestamp with time zone'
without need it because i have read in the mailing list was good practice
because maybe one day you use the database in more timezones but i ever use the
app in the same timezone so i will convert the column datatype where i need an
index in a cast to date from a timestamp. Thanks.

Chris Spotts escribió:
>> 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.
>