Re: plpgsql multidimensional array assignment results in array of text instead of subarrays

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: plpgsql multidimensional array assignment results in array of text instead of subarrays
Дата
Msg-id 1478.1451346710@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: plpgsql multidimensional array assignment results in array of text instead of subarrays  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: plpgsql multidimensional array assignment results in array of text instead of subarrays  (Michael Rasmussen <michaelr@porch.com>)
Список pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> ​or a more semantically meaning one...the use of the inner array is
> arguably a hack here meant to avoid the overhead and new type creation by
> assigning meaning to array slots.

Yeah, good point: it looks like Mike does not consider the columns of
the array to be interchangeable at all, so really he would be better
off modeling the data as you suggest.

            regards, tom lane


В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: plpgsql multidimensional array assignment results in array of text instead of subarrays
Следующее
От: Michael Rasmussen
Дата:
Сообщение: Re: plpgsql multidimensional array assignment results in array of text instead of subarrays