Re: Is there a type like a growable array, similar Vector at - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Is there a type like a growable array, similar Vector at
Date
Msg-id 42E2120A.6080003@archonet.com
Whole thread Raw
In response to Is there a type like a growable array, similar Vector at Java language in postgreSQL?  ("Dongsoo Yoon" <dsyoon@metasoftworks.com>)
List 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


pgsql-sql by date:

Previous
From: "Dongsoo Yoon"
Date:
Subject: Is there a type like a growable array, similar Vector at Java language in postgreSQL?
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: Multi-column returns from pgsql