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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: plpgsql multidimensional array assignment results in array of text instead of subarrays
Дата
Msg-id CAKFQuwaUDFarr5Zs287Cnm35dVPSzSSs3jCSG6O_vqqTu3y6WA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plpgsql multidimensional array assignment results in array of text instead of subarrays  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: plpgsql multidimensional array assignment results in array of text instead of subarrays  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения
On Mon, Dec 28, 2015 at 4:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Michael Rasmussen <michaelr@porch.com> writes:
> I am trying to iterate through a multidimensional array using a foreach loop, as exampled in the documentation at http://www.postgresql.org/docs/9.4/static/plpgsql-control-structures.html#PLPGSQL-FOREACH-ARRAY.

create type textarray as (t text[]);

​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.

​i.e.,​

create type table_with_schema (name text, schema text);

I would likewise attempt to do away with the outer array as well if the overall structure of the example follows reality closely enough.

​David J.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: 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