AGGR_TIMESTAMPTZ ON|OFF
Timestamp with timezone values are normalized for grouping or not normalized for grouping during aggregation, when used in the group by-clause.
Normalization here means, that two timestamps, which denote the same UTC point in time, compare as equal for grouping purposes. Valid values are:
ON-(Default) Values are normalized during aggregation.
OFF-Values are not normalized during aggregation.
The values can be set at the session level as:
• set aggr_timestamptz on
• set aggr_timestamptz off
Note: Even if the aggr_timestamptz is off, two different values which denote the same UTC point in time compare as equal anywhere else, except for grouping purposes.
Note: Only one value (not normalized) can be displayed as the value for the group when aggr_timestamptz is enabled. For heap tables, the first entry is chosen, while for x100 tables, the minimum value when comparing all values in a non-normalized fashion is chosen.
For X100 tables, normalization is enabled or disabled for the UNION operator. For non-X100 tables, the parameter will not impact the UNION operator as the output is always normalized.
Last modified date: 04/26/2024