Postgres Pro
Downloads
Home   >   mailing lists

Re: date is not immutable ? - Mailing list pgsql-admin

From xach@xach.com (Zachary Beane)
Subject Re: date is not immutable ?
Date
Msg-id slrnb6sdcb.25l.xach@localhost.localdomain
Whole thread Raw
In response to date is not immutable ?  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
Tree view 
In article <b4labj$15lq$1@news.hub.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

pgsql-admin by date:

Previous
From: gborges@radiumsystems.com.br
Date:
Subject: Re: Miss of global directory
Next
From: Christopher Browne
Date:
Subject: Re: Largest filesize under Linux