plpgsql : looping over multidimensional array : getting NULL for subdimension

Поиск
Список
Период
Сортировка
От Samba
Тема plpgsql : looping over multidimensional array : getting NULL for subdimension
Дата
Msg-id AANLkTikR3fpd_OArX9-ZDry4S0RwXYA7zB+FhUhf8Awb@mail.gmail.com
обсуждение исходный текст
Ответы plpgsql : looping over multidimensional array : getting NULL for subdimension  (Vinicio Nocciolini <vnocciolini@mbigroup.it>)
Список pgsql-general
Hi all,

      I'm trying to loop over a multidimensional array and find if any of the elements in a sub-dimensional array are matching some known criteria but facing issue with NULL for the sub arrays.

I have a data structure that looks like:

   some_array VARCHAR[][] := '{{samba,sarath,sreenivas},{samba,mukhesh,pavan}}';

I'm trying to assign the individual sub arrays to other array elements like:

  other-array VARCHAR[];

  other_array=some_array[1];


and I'm expecting to get '{samba,sarath,sreenivas}' for index 1 and {samba,mukhesh,pavan} for index 2;
however, I'm getting NULL.

Can some one explain the way I can assign subarrays to other array elements plpgsql?

Thanks and Regards,
Samba

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

Предыдущее
От: Gary Chambers
Дата:
Сообщение: Re: Grant command help -- postgres
Следующее
От: "Jolles, Peter M (GE Energy)"
Дата:
Сообщение: Cannot start Postgres- FATAL: invalid cache id: 19