Received: from plasma.ernet.in (root@[202.41.112.101]) by hub.org (8.9.1/8.9.1) with SMTP id HAA17860 for ; Thu, 19 Nov 1998 07:02:45 -0500 (EST) (envelope-from hkg@plasma.ernet.in) Received: from arjuna.plasma.ernet.in (arjuna.plasma.ernet.in [202.41.112.1]) by plasma.ernet.in (8.6.12/8.6.12) with SMTP id RAA04023 for ; Thu, 19 Nov 1998 17:19:05 +0500 Received: from sun4.plasma.ernet.in by arjuna.plasma.ernet.in; (5.65/1.1.8.2/03Oct95-1236PM) id AA05571; Thu, 19 Nov 1998 17:34:17 +0530 Sender: hkg@plasma.ernet.in Message-Id: <36549C92.660@plasma.ernet.in> Date: Thu, 19 Nov 1998 17:32:50 -0500 From: Hitesh Kumar Gulati Organization: I.P.R. X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5 sun4u) Mime-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Problem Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit How to update a particular element of a field of data type array . I am using update and set combined statement .It is accepting but it is not displaying with select statement. -- create table test( shotno int4 not null, data int2[], constraint chk_shot check(shotno >= 0) ); update test set data[1]= %d where shotno=2929; Hitesh kumar Gulati E-mail-:hkg@plasma.ernet.in Ph. (079)-2864023 (O) Engineer - SC Institute For Plasma Research Near Indira Bridge Bhat Gandhinagar(GUJARAT)