| From: | Linos <info(at)linos(dot)es> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | type cast in index |
| Date: | 2009-06-09 16:20:21 |
| Message-ID: | 4A2E8BC5.8080902@linos.es |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Octavio Alvarez | 2009-06-09 16:25:14 | Re: limit table to one row |
| Previous Message | Chris Browne | 2009-06-09 16:14:30 | Re: Can postgresql store its data on raw device now? |