I need write a query like this
select coalesce_agg(col order by col asc) from some_table group by other_col
clearly the col column is nullable.
which is the best way (in terms of performance too) to obtain this?
Are there any built-in aggregate function or should I write a new aggregate function with CREATE AGGREGATE?
Do you think coalesce_agg should be a built-in aggregation?
Thanks in advance