Re: array bad behavior? - Mailing list pgsql-general

From Tom Lane
Subject Re: array bad behavior?
Date
Msg-id 2791.990740364@sss.pgh.pa.us
Whole thread Raw
In response to array bad behavior?  ("Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu>)
List pgsql-general
"Thalis A. Kalfigopoulos" <thalis@cs.pitt.edu> writes:
> Then I insert:
> insert into lala values(1003,'{{"1_1","1_2"},{"2_1"}}');

IIRC, the array code is fairly buggy for non-rectangular arrays.
The array parser doesn't really do these correctly, and even if it
did, the *right* behavior IMHO would be to fill the missing elements
with NULLs, which can't be done yet because the array representation
doesn't handle NULL elements.

Someone needs to work on it --- want to volunteer?

            regards, tom lane

pgsql-general by date:

Previous
From: "Steven D. Arnold"
Date:
Subject: strange stored procedure problem
Next
From: Vince Vielhaber
Date:
Subject: RE: ERWin