Linos 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 You can make it work by adding an AT TIME ZONE 'UTC' specification, which will cause it to be turned into a plain timestamp (without tz). -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
