Is there a single function that will generate a series and return an array?
The best I've come up with is to combine array_agg and generate_series:
SELECT array_agg(generate_series) FROM generate_series(5, 23);
array_agg
---------------------------------------------------------
{5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23}
Thanks,
--Lee
--
Lee Hachadoorian
PhD, Earth & Environmental Sciences (Geography)
Research Associate, CUNY Center for Urban Research
http://freecity.commons.gc.cuny.edu/