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”.

Environment

None

Activity

Fixed

Details

Assignee

Reporter

Components

Fix versions

Priority

Created November 18, 2022 at 7:02 AM
Updated January 3, 2023 at 12:19 PM
Resolved November 21, 2022 at 12:56 PM