date is not immutable ?

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: date is not immutable ?
Date: 2003-03-11 18:37:04
Message-ID: b4labj$15lq$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,
I'm trying to create an index on a timestamptz field just extracting the
date:

# create index idx_user_logs_login_time_date on user_logs (
date(login_time) );
ERROR: DefineIndex: index function must be marked IMMUTABLE

why date is not marked immutable ?

Regards
Gaetano

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Byron A Jeff 2003-03-11 18:41:31 Re: Largest filesize under Linux
Previous Message Partho Bhowmick 2003-03-11 17:31:54 Largest filesize under Linux