Search Postgresql Archives

[8.1.4] Create index on timestamp fails

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Title: [8.1.4] Create index on timestamp fails

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux