I faced the same. But an array in my case is created via array_agg
function. And fortunately it allows to aggregate DISTINCT values, like:
array_agg(DISTINCT value)
This works for me.
I faced the same. But an array in my case is created via array_agg
function. And fortunately it allows to aggregate DISTINCT values, like:
array_agg(DISTINCT value)
This works for me.