Re: BUG #4509: array_cat's null behaviour is inconsistent - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #4509: array_cat's null behaviour is inconsistent
Date
Msg-id 4919A1AB.3030502@gmx.net
Whole thread Raw
In response to Re: BUG #4509: array_cat's null behaviour is inconsistent  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane wrote:
> It's really all kind of messy ... we need to trade off simplicity of
> definition, ease of use, backwards compatibility, and standards
> compliance (though the standard has only 1-D arrays so it's of just
> limited help here).

AFAICT, the standard would certainly allow a type specification of

    basetype ARRAY ARRAY ARRAY ...

which gives you a multidimensional array (in the same sense that C has
multidimensional arrays).  If my reading of everything is right, the
subscript order that this would require is the opposite of what
PostgreSQL uses for multidimensional arrays.  Talk about messy ...

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4520: Cases where a forign key constraint is not inforced and when it is incorrectly inforced.
Next
From: Jeff Davis
Date:
Subject: possible array parsing bug