Updating non atomic values

Bob Kruger <bkruger@mindspring.com>

From: Bob Kruger <bkruger@mindspring.com>
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Date: 1999-06-08T17:27:30Z
Lists: pgsql-general, pgsql-sql
Is there a way to update non atomic values in Postgres?

Example:

update t3 set t3.fld[1] = 0 where t3.fld[1] = 5 ;

The above example bombs every time.  

Any hints?

Bob