X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 87807529CC for ; Sat, 23 Jul 2005 07:00:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56631-06 for ; Sat, 23 Jul 2005 10:00:27 +0000 (GMT) Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by svr1.postgresql.org (Postfix) with ESMTP id A9A15529BD for ; Sat, 23 Jul 2005 07:00:26 -0300 (ADT) Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id ECEDA416D96; Sat, 23 Jul 2005 11:00:17 +0100 (BST) Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id D1FC915EE6; Sat, 23 Jul 2005 10:46:53 +0100 (BST) Received: from mainbox.archonet.com ([127.0.0.1]) by localhost (mainbox [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00905-01; Sat, 23 Jul 2005 10:46:51 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id DA3AE15ED9; Sat, 23 Jul 2005 10:46:50 +0100 (BST) Message-ID: <42E2120A.6080003@archonet.com> Date: Sat, 23 Jul 2005 10:46:50 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Dongsoo Yoon Cc: pgsql-sql@postgresql.org Subject: Re: Is there a type like a growable array, similar Vector at References: <000a01c58e86$d63cae30$6a0aa8c0@notebook04> In-Reply-To: <000a01c58e86$d63cae30$6a0aa8c0@notebook04> Content-Type: text/plain; charset=EUC-KR Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.056 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200507/207 X-Sequence-Number: 22185 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