Bernie Huang <[EMAIL PROTECTED]> writes:
> however, that might be troublesome, so I tried
> UPDATE table
> SET arr[1]=val1
> arr[2]=val2...
> but it didn't work.
Hmm, probably not ... I don't see any easy way around that, since
the array elements aren't really separate fields. Under the hood
Jouni Ahto wrote:
> On Thu, 13 Jul 2000, Bernie Huang wrote:
>
> > I want to update the last three element without affecting other
> > elements. I could have done it by retrieving all elements in the array
> > first and the do a
> >
> > UPDATE table
> > SET arr='{"1","2","3","4","5"}'
> > WHERE
