how can i mark date function like iscachable - Mailing list pgsql-general

From erobles
Subject how can i mark date function like iscachable
Date
Msg-id 4A77347B.4050304@sensacd.com.mx
Whole thread Raw
Responses Re: how can i mark date function like iscachable
Re: how can i mark date function like iscachable
List pgsql-general
erobles wrote:
> Hello there!
>
> i tried to  create an functional index  like this:
>
> create index estdistfecha on estadist (date(fecha));
>
>
> but only get the  next message:
> ERROR: DefineIndex: index function must be marked iscachable.
>
> So, How can i mark the date function iscachable ? :-)
>
> i hope your anwsers, anyway thanks to read this !
>
>
>


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Privilege problems: access denied on select for owner?
Next
From: erobles
Date:
Subject: Re: how can i mark date function like iscachable