type cast in index

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: Raw Message | Whole Thread | 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.

Responses

Browse pgsql-general by date

  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?