From: | prakashn(at)uci(dot)edu |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Relative ordering in array aggregation |
Date: | 2011-02-09 19:16:44 |
Message-ID: | 1926da192bd2b048d0b19ba22a55141c.squirrel@webmail.uci.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm using 8.3.3. I came across the array_accum aggregate function in
the docs:
http://www.postgresql.org/docs/8.3/interactive/xaggr.html
CREATE AGGREGATE array_accum (anyelement)
(
sfunc = array_append,
stype = anyarray,
initcond = '{}'
);
This would be very useful to me, but I have a question about ordering
of values. If I use more than one array_accum in the same select
clause, is there any reliable correspondence between the order of
elements in the returned arrays? In other words, if a have a table
foo like so:
a b c
----+----+----
aaa | 12 | a1
aaa | 13 | a2
and I run
select a, array_accum (b), array_accum (c) from foo group by a;
then can I expect that the results will always be one of
aaa | {12, 13} | {a1, a2}
or
aaa | {13, 12} | {a2, a1}?
OR, could the query also return the arrays as
aaa | {13, 12} | {a1, a2}
or
aaa | {12, 13} | {a2, a1}?
If so, would there be any way to enforce the first behaviour?
Thanks,
nishad
From | Date | Subject | |
---|---|---|---|
Next Message | David Kerr | 2011-02-09 19:23:19 | Re: pg_dump: schema with OID 58698 does not exist |
Previous Message | Tom Lane | 2011-02-09 19:15:06 | Re: pg_dump: schema with OID 58698 does not exist |