Array operator "sum array values" + matching dimensions

From: Scara Maccai <m_lists(at)yahoo(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Array operator "sum array values" + matching dimensions
Date: 2008-04-03 07:38:12
Message-ID: 520692.23475.qm@web28104.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

Browse pgsql-general by date

  From Date Subject
Next Message Leif B. Kristensen 2008-04-03 08:18:47 Re: simple update queries take a long time - postgres 8.3.1
Previous Message Albe Laurenz 2008-04-03 07:25:57 Re: Foreign keys causing conflicts leading toserialization failures