>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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
