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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org