Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA13690; Tue, 22 Sep 92 19:02:16 -0700
Date: Tue, 22 Sep 92 19:02:16 -0700
From: Otago University Database Research Group <DBPOST@otago.ac.nz>
Subject: <<<< UPDATING ARRAYS >>>>
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Message-Id: <01GP4K0JCQWGAIBWIQ@otago.ac.nz>
X-Envelope-To: postgres@postgres.berkeley.edu
X-Vms-To: IN%"postgres@postgres.berkeley.edu"

With regards to attributes of type array e.g text[100], is it possible once
values have already been entered and saved to then update this list with extra
elements. For example if text[1] and text[2] contain values that have been
inserted using
               append <rname>(textattr="{"Fred","Sam"}")
it would be convenient to be able to add to this list using
               append <rname>(textattr[3] = "{"Andrew"}")
this obviously isn't supported as it doesn't work. Is there any other way I acn
go about updating an array?


One other question : Sets as attributes are not supported - would this not be a
simple to define user type or are there hidden complexities involved?

Thanks for your help,
Andrew White
        WHITEY@otago.ac.nz