Re: Is there a type like a growable array, similar Vector at

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

In response to

Browse pgsql-sql by date

  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