On 12/9/20 5:04 PM, avi Singh wrote: > Thanks for your reply Adrian > > > What do you want to do with the array? > i want to do a sum of the values of numeric array type column e.g. below > data_numeric > -------------- > {2.0} > {1.0}
If you are going to have a single element arrays only then why not just use a numeric field?
To answer question:
select sum(data_numeric[1]) from some_table;
If you are going to have multi-element arrays then there are more questions: