In article <b4labj$15lq$1(at)news(dot)hub(dot)org>, Gaetano Mendola wrote:
> 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 ?
It is influenced by the local time zone.
Zach