Re: date is not immutable ?

"Zachary Beane" <xach(at)xach(dot)com> wrote in message
news:slrnb6sdcb(dot)25l(dot)xach(at)localhost(dot)localdomain(dot)(dot)(dot)
> 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.

Do you know another way to improve the select:

SELECT * FROM T WHERE date(login_time) = now()::date;

Regards
Gaetano