Re: array bad behavior?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: array bad behavior?
Date: 2001-05-24 21:39:24
Message-ID: 2791.990740364@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Thalis A. Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vince Vielhaber 2001-05-24 22:00:43 RE: ERWin
Previous Message Steven D. Arnold 2001-05-24 20:16:19 strange stored procedure problem