On 29/11/2010 16:56, Zhipan Wang wrote:
> Since in-place seems not possible, I am trying to use arrays to store
> different ranges of that column, and it's fast to fetch a big array,
> so I believe an array is stored continuously on disk.
>
> I can convert an array to a column easily by unnest() function, but I
> didn't find any function that converts a column to an array. Is there
> a efficient method to do that?
I think array_agg() is what you want.
http://www.postgresql.org/docs/9.0/static/functions-aggregate.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie