v.25.6Improvement
Support anyLast_respect_nulls and any_respect_nulls as a SimpleAggregateFunction
SupportanyLast_respect_nullsandany_respect_nullsas aSimpleAggregateFunction. #80219 (Diskein).
Why it matters
This feature allows users to apply the aggregation functionsanyLast_respect_nulls and any_respect_nulls within the SimpleAggregateFunction wrapper. It addresses the need to respect NULL values during aggregation, providing more precise control when aggregating values that may contain NULLs.How to use it
Users can now useanyLast_respect_nulls and any_respect_nulls by specifying them inside SimpleAggregateFunction like so:SELECT <code>SimpleAggregateFunction</code>(<code>anyLast_respect_nulls</code>, <column>) FROM <table>;or
SELECT <code>SimpleAggregateFunction</code>(<code>any_respect_nulls</code>, <column>) FROM <table>;