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
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 |