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
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
