PostgreSQL: trunc(timestamp,format) missing version for TIMESTAMP WITHOUT TIME ZONE
Description
In current PostgreSQL seed, we have trunc(datetime TIMESTAMP WITH TIME ZONE, format varchar) but is missing trunc(datetime TIMESTAMP WITHOUT TIME ZONE, format varchar).
Due to that, “create index fact_acct_dateacct_mm_idx on fact_acct(ad_client_id, trunc(dateacct, 'MM'), postingtype);” will fail with the error “ERROR: functions in index expression must be marked IMMUTABLE”.
In current PostgreSQL seed, we have trunc(datetime TIMESTAMP WITH TIME ZONE, format varchar) but is missing trunc(datetime TIMESTAMP WITHOUT TIME ZONE, format varchar).
Due to that, “create index fact_acct_dateacct_mm_idx on fact_acct(ad_client_id, trunc(dateacct, 'MM'), postingtype);” will fail with the error “ERROR: functions in index expression must be marked IMMUTABLE”.