[8.1.4] Create index on timestamp fails

From: "Arturo Perez" <aperez(at)hayesinc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: [8.1.4] Create index on timestamp fails
Date: 2006-08-21 21:06:07
Message-ID: 4AA304A4DBB6414199F18D7E324EBDE9016C04BF@HAYES3.HAYESINC.ORG
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Using postgresql 8.1.4....

I have a table with an column:
entry_date | timestamp with time zone| not null

And when I try to create an index on it like so:
create index entry_date_idx on user_tracking(date_part('year',entry_date));

I get a
ERROR: functions in index expression must be marked IMMUTABLE

According to the mailing lists, this has been working since 7.4. What am I doing wrong?

tia,
arturo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-08-21 21:32:33 Re: Queries joining views
Previous Message DelGurth 2006-08-21 20:57:52 Re: Queries joining views