> Thanks for the reply. > > My problem is that I can't have the array with all items. I need to read from a > table and store in an Array the values.
Not sure if i understand you, but how about:
test=*# select * from foo; a --- 1 3 5 7 (4 Zeilen)
Zeit: 0,203 ms test=*# select array_agg(a) from foo; array_agg ----------- {1,3,5,7} (1 Zeile)
The function returns a column as an array.
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°
