How to sum array field values ​​in postgresql?

Question

PostgreSQL

Here is a request

with rec as (select "recordId" as rec_id from catalog_12_links where "catalogRecordId"=1) select field7[1] as s from catalog_12_data where "id" in (select rec_id from rec) and field4 = '{2}';

gives this result

s
---
 2
 2
(2 rows)

how to get the sum of these values? and also tell me what exactly to read, so that I myself guessed

Answer 1

https://www.postgresql.org/docs/current/static/fun... sum