type cast in index
| От | Linos |
|---|---|
| Тема | type cast in index |
| Дата | |
| Msg-id | 4A2E8BC5.8080902@linos.es обсуждение исходный текст |
| Ответы |
Re: type cast in index
Re: type cast in index |
| Список | pgsql-general |
Hello,
i have reading in the mailing list any messages where different people use this
format to establish a functional index in a column using a type cast.
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
I have tried with the typical CAST too but i get the same error, the column in
the table is:
Column | Type |
Modifiers
time_stamp_creacion | timestamp with time zone | default now()
What can be the problem? Thanks.
Regards,
Miguel Angel.
В списке pgsql-general по дате отправления: