Re: Problem

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
>
>