>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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to