From: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: array question |
Date: | 2009-10-09 20:17:03 |
Message-ID: | 20091009201703.GA19898@tux |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Whit Armstrong <armstrong(dot)whit(at)gmail(dot)com> wrote:
> That's exactly what I needed. Thanks very much!
If you have 8.4, you can use the build-in function array_agg() instead:
test=*# select * from x;
a | b
---+---
1 | 1
1 | 2
1 | 3
2 | 1
2 | 4
(5 Zeilen)
Zeit: 0,203 ms
test=*# select a, array_agg(b) from x group by a;
a | array_agg
---+-----------
1 | {1,2,3}
2 | {1,4}
(2 Zeilen)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
From | Date | Subject | |
---|---|---|---|
Next Message | Spotts, Christopher | 2009-10-09 20:27:14 | array_agg performance |
Previous Message | Mike Diehl | 2009-10-09 19:53:56 | Stuck vacuum... |