Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA26382; Wed, 25 Nov 92 09:17:53 -0800
Message-Id: <9211251717.AA26382@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: Desperately need help on updating arrays
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Wed, 25 Nov 92 03:34:42 PST.
             <01GRL5DCBU0GFD4IS6@otago.ac.nz> 
Date: Wed, 25 Nov 92 09:17:48 PST

In message <01GRL5DCBU0GFD4IS6@otago.ac.nz> you write:

> I desperately need to know if it is possible to update an element of an array
> i.e something along the lines of :
> 
> replace PERSON(cars[3] = "Ferrari") where PERSON.Name="Andrew White"
> 
> this does not work as the parser gets hung up on the first "[". Could anyone
> that has a solution PLEASE email me on in%"whitey@otago.ac.nz"

4.0.1 doesn't support updates on single array elements; you have to replace
the entire array.