Greetings. I recently encountered a problem updating an array element on
a temp table. Instead of updating just the specified array element, it
copies the array values onto all the tuples. The command works as
expected with regular tables.
create temp table tmpArray ( id int4, val int4[]
);
CREATE
insert into tmpArray values (1, '{1,2,3,4}');
INSERT 24630506 1
insert into tmpArray values (2, '{4,3,2,1}');
INSERT 24630507 1
insert into tmpArray values (3, '{9,10,11,12}');
INSERT 24630508 1
select * from tmpArray;
id|val
--+------------1|{1,2,3,4}2|{4,3,2,1}3|{9,10,11,12}
(3 rows)
update tmpArray set val[3] = 7;
UPDATE 3
select * from tmpArray;
id|val
--+---------1|{1,2,7,4}2|{1,2,7,4}3|{1,2,7,4}
(3 rows)
drop table tmpArray;
DROP
EOF
- K
Kristofer Munn * KMI * 973-509-9414 * AIM KrMunn * ICQ 352499 * www.munn.com