Bug #876: Bugs Inserts Arrays - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #876: Bugs Inserts Arrays
Date
Msg-id 20030115230958.476564770ED@postgresql.org
Whole thread Raw
Responses Re: Bug #876: Bugs Inserts Arrays  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Walter (wgpalumbo@yahoo.com.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[][]);
//it´s 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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #875: init script problem with reload
Next
From: Tom Lane
Date:
Subject: Re: Bug #876: Bugs Inserts Arrays