RE: [HACKERS] Arrays broken on temp tables

Sorry, all; ignore the last mail; I was having a stupid attack.

-----Original Message-----
From: Kristofer Munn
To: pgsql-hackers@postgreSQL.org
Sent: 99/11/06 10:09
Subject: [HACKERS] Arrays broken on temp tables

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


************