Re: BUG #4509: array_cat's null behaviour is inconsistent

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: BUG #4509: array_cat's null behaviour is inconsistent
Дата
Msg-id 4919A1AB.3030502@gmx.net
обсуждение исходный текст
Ответ на Re: BUG #4509: array_cat's null behaviour is inconsistent  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4520: Cases where a forign key constraint is not inforced and when it is incorrectly inforced.
Следующее
От: Jeff Davis
Дата:
Сообщение: possible array parsing bug