Received: from smtp2.mindspring.com (smtp2.mindspring.com [207.69.200.32]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA01746; Tue, 8 Jun 1999 13:29:59 -0400 (EDT) (envelope-from bkruger@mindspring.com) Received: from oplsrv3 (user-38h1sas.dialup.mindspring.com [209.16.241.92]) by smtp2.mindspring.com (8.8.5/8.8.5) with SMTP id NAA20446; Tue, 8 Jun 1999 13:29:53 -0400 (EDT) Message-Id: <3.0.5.32.19990608122730.007b4d50@mindspring.com> X-Sender: bkruger@mindspring.com X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Tue, 08 Jun 1999 12:27:30 -0500 To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org From: Bob Kruger Subject: Updating non atomic values Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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