Array operator "sum array values"

[Scara Maccai <m_lists(at)yahoo(dot)it>]

Hi,

is there a syntax that sums the values of an array?

That is, having an array like

{1,3,8},{5,6,7}

something like 

select arr[1:2][2:3]

gives

{1,3},{6,7}


; what I'd like is:

select arr[1$2][2$3]

gives:

17 (that is, 1+3 + 6+7)

If there is no such operator, would it be complicated adding it to postgres? 
I mean: is the "[:]" operator an internal thing (the parser "knows" about it) or is it just like any other operators that can be added ?









      ___________________________________ 
Scopri il Blog di Yahoo! Mail: trucchi, novità, consigli... e la tua opinione!
http://www.ymailblogit.com/blog/