From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Dongsoo Yoon <dsyoon(at)metasoftworks(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Is there a type like a growable array, similar Vector at |
Date: | 2005-07-23 09:46:50 |
Message-ID: | 42E2120A.6080003@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Dongsoo Yoon wrote:
> In Oracle, there is a type like a growable array, similar Vector at
> Java language.
I always find the manuals good for this information. Looking in the
section on "Arrays", in "Data Types"
BEGIN QUOTE
A stored array value can be enlarged by assigning to an element adjacent
to those already present, or by assigning to a slice that is adjacent to
or overlaps the data already present. For example, if array myarray
currently has 4 elements, it will have five elements after an update
that assigns to myarray[5]. Currently, enlargement in this fashion is
only allowed for one-dimensional arrays, not multidimensional arrays.
END QUOTE
Is that helpful?
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Buttafuoco | 2005-07-23 12:57:38 | Re: Multi-column returns from pgsql |
Previous Message | Tom Lane | 2005-07-23 04:56:26 | Re: Error when using array variable |