Received: from naveen.ncst.ernet.in (naveen.ncst.ernet.in [202.41.110.35]) by hub.org (8.9.1/8.9.1) with ESMTP id FAA13076 for ; Tue, 24 Nov 1998 05:36:11 -0500 (EST) (envelope-from hkg@shakti.ncst.ernet.in) Received: from shakti.ncst.ernet.in (shakti.ncst.ernet.in [202.141.150.17]) by naveen.ncst.ernet.in (8.9.1/8.9.1) with ESMTP id QAA07857 for ; Tue, 24 Nov 1998 16:04:27 +0530 (GMT+05:30) Received: (Uipr@localhost) by shakti.ncst.ernet.in (8.7.5/8.6.8) id PAA14133 for pgsql-sql@postgresql.org; Tue, 24 Nov 1998 15:56:36 +0530 (GMT) X-Authentication-Warning: shakti.ncst.ernet.in: Uipr set sender to hkg using -f 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 JAA07756 for ; Tue, 24 Nov 1998 09:00:37 +0500 Received: from sun13.plasma.ernet.in by arjuna.plasma.ernet.in; (5.65/1.1.8.2/03Oct95-1236PM) id AA29424; Tue, 24 Nov 1998 09:13:35 +0530 Sender: hkg@plasma.ernet.in Message-Id: <365ABE91.3672@plasma.ernet.in> Date: Tue, 24 Nov 1998 09:11:52 -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: Re: Problem References: <36549C92.660@plasma.ernet.in> 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 > hkg@plasma.ernet.in > >