From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug #876: Bugs Inserts Arrays |
Date: | 2003-01-15 23:09:58 |
Message-ID: | 20030115230958.476564770ED@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Walter (wgpalumbo(at)yahoo(dot)com(dot)br) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Bugs Inserts Arrays
Long Description
Hi, Im Walter, from Brazil, and I use PG 7.2.
(excuse my english!)
The error: the last entrance (last array
dimension) determine the dimension of all arrays,
losting data information.
see the example:
all of array has 2 elements. The error: the last entrance (last array
dimension) determine the dimension of all arrays,
losting data information (the information "002" of first array is lost).
If I make a mistake, forgot it, but if not, please, report me something !
Thanks a Lot
Walter
Sample Code
create table teste(serie integer,aula text[][]);
//its ok when insert this
insert into teste values (1,'{{"004","009"},{"009"},{""},
{"001","002"}}');
//But when I insert this..
insert into teste values
(1,'{{"004","009","002"},{"009","001"},{""},{"001","002"}}');
^^^^^^ -> lost information ^^^^^^^^^^ -> array dimension last entrance.
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-16 01:12:06 | Re: Bug #876: Bugs Inserts Arrays |
Previous Message | pgsql-bugs | 2003-01-15 11:07:45 | Bug #875: init script problem with reload |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-01-15 23:44:14 | Re: SQL flagger |
Previous Message | Rod Taylor | 2003-01-15 21:16:36 | Re: inet regression test |