date is not immutable ? - Mailing list pgsql-admin

From Gaetano Mendola
Subject date is not immutable ?
Date
Msg-id b4labj$15lq$1@news.hub.org
Whole thread Raw
Responses Re: date is not immutable ?
List 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



pgsql-admin by date:

Previous
From: Michael Brusser
Date:
Subject: Upgrade 7.2.1 to 7.3
Next
From: ApoloDNR
Date:
Subject: Re: character set