wrong?
On Mon, Jun 12, 2017 at 2:25 PM, Olav Gjerde wrote:
> I have a table that I try create an functional index on like this:
>
> CREATE INDEX my_index_name
> ON opening_hours (
> opening_hours_type,
> EXTRACT(YEAR FROM date),
> EXTRACT(MONTH FROM date)
> )
>
I have a table that I try create an functional index on like this:
CREATE INDEX my_index_name
ON opening_hours (
opening_hours_type,
EXTRACT(YEAR FROM date),
EXTRACT(MONTH FROM date)
)
But I get the following error: functions in index expression must be
marked IMMUTABLE
But if I cha
