| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Zhipan Wang <wzhipan(at)soe(dot)ucsc(dot)edu> |
| Cc: | Guillaume Lelarge <guillaume(at)lelarge(dot)info>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question about OID and TCID |
| Date: | 2010-11-29 17:02:30 |
| Message-ID: | 4CF3DCA6.6060506@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2010-11-29 17:18:40 | PostgreSQL hanging on new connections? |
| Previous Message | Zhipan Wang | 2010-11-29 16:56:46 | Re: Question about OID and TCID |