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
Дата	28 декабря 2015 г. 23:48:36
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
Список	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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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