Array operator "sum array values" + matching dimensions
От
Scara Maccai
Тема
Array operator "sum array values" + matching dimensions
Дата
Msg-id
520692.23475.qm@web28104.mail.ukl.yahoo.com
Список
> create or replace function sum_elements(anyarray)
> returns anyelement as $$
> select sum($1[i])
> from generate_series(array_lower($1,1),
> array_upper($1,1)) g(i);
> $$ language sql immutable;
Thank you! Anyway what I was really asking was a "$" (or whatever other symbol) in place of ":" for sum, that is a notation like
myarray_col[12$16]
would give the sum of all values from myarray_col[12] to myarray_col[16]
Anyway, I was reading that multidimensional arrays must have matching dimensions (that is, they can't be, for example, [5][9]).
Is this right? Why is that?
Thank you
Inviato da Yahoo! Mail.
La casella di posta intelligente.
http://it.docs.yahoo.com/mail/overview/index.html
В списке pgsql-general по дате отправления
От: Albe Laurenz
Дата:
От: Leif B. Kristensen
Дата: